How to get results from a joined query

[eluser]vitoco[/eluser]
hi , i don't know exactly how "GROUP_CONCAT" works , but you can explicitly set the field name with 'AS' in this way

Code:

SELECT    
    a.users_id,
    a.users_username,
    GROUP_CONCAT(b.game_id SEPARATOR ' ' ) AS game_id
FROM
    users AS a
JOIN
    usergames AS b
ON
    ( a.users_id = b.user_id )
GROUP
    BY users_id

see if it works , if not..post the table script so i'll be able to run some tests.

Bye