Re: Merging the results of multiple tables

[Chris Stubben]

Hi,

The GROUP_CONCAT() function in 4.1 is really useful, you can even order the list by a column name and change the delimiter (default is a comma).

http://dev.mysql.com/doc/mysql/en/group-by-functions.html

Your query would look something like this.

SELECT u.name, u.alias, GROUP_CONCAT(s.song),
FROM users u, songs s
where u.id=s.user_id
GROUP BY u.name, u.alias;


Chris