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