Results 1 to 6 of 6
Thread: INNER JOIN question
Sep 11, 2013, 07:08 #1
INNER JOIN question
I have the following INNER JOIN in one of my select queries, but it only fetches the ID of the industry. I need to get the industry name which is stored in another table ("industries"). How can I do that?
INNER JOIN ( SELECT user_id, group_concat( industry_id SEPARATOR ',' ) AS industry FROM users_industries GROUP BY user_id ) AS i ON i.user_id = users.id