Hi

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?

Code:
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
Thanks in advance.