I have two table
One each user have manay servics e.g
user "john
" have many record in servies
as PHP
, HTML
, SEO
I want to show each user services as follow
user_name ---------------servies
john --------------------PHP, HTML,SEO
Miky --------------------Java, C# , Objective C
I want select query of this results
SELECT user_name,GROUP_CONCAT(service_name) FROM user
JOIN servies
ON user.user_id=servies.user_id
GROUP BY user_name