Inner Join is grouping rows

Chantalr99 96 Reputation points
2021-09-14T12:28:32.897+00:00

131977-image.png

HI there, when I do this inner join, its grouping my bends rather than showing them one by one in rows. It will show one for all the bends of the same type. I don't know how to join these tables ( which I'm doing to apply the names) without the bends grouping themselves. I need to see each individual bend.

Thanks
131945-image.png

Azure Database for MySQL
Azure Database for MySQL
An Azure managed MySQL database service for app development and deployment.
502 questions
Not Monitored
Not Monitored
Tag not monitored by Microsoft.
27,004 questions
Accepted answer
  1. Chantalr99 96 Reputation points
    2021-09-15T13:25:05.487+00:00

    I found that the table "Bystronic_Log" was grouping the rows, not my query so I quit linking to that table and created smaller tables to access the data points I needed out of it.

    0 comments

1 additional answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Olaf Helper 28,936 Reputation points
    2021-09-14T12:54:35.047+00:00

    A JOIN never forces an implicit grouping of the data.

    What's that for a tool in the second screenshot? Looks like PowerPivot/PowerQuery?
    I see at least one active filter on column "BendCount"; may does that causes that you see a limited result?