How to use select the appropriate column in GROUP BY

Viewed 13

while using group by command if both tables have customer_id column then which table column should we use in the below illustration please tell me how to select the table:

FROM A

INNER JOIN B ON A.customer_id = B.customer_id

GROUP BY A.customer_id

I'm really having a hard time determining the appropriate column when combined with a JOIN where both tables have that table

0 Answers
Related