GROUP CONCAT on 2 tables

[Paul Polin]

I need a group_concat on 2 tables, I can get it working with 1 but not with 2

SELECT r.user_id, GROUP_CONCAT(p.name) AS members
FROM table1 r INNER JOIN table2 p on p.user_id = r.user_id
GROUP BY p.user_id ;

I get for each row many times the same name

user_id ---- members

128 ---- Paul,Paul,Paul
248 ---- Piotr, Piotr

how can I get it ?

thank you



Edited 2 time(s). Last edit at 06/22/2012 05:16AM by Paul Polin.