> Currently I have a query that is able to return (doing a left join): > 'A', 'B', 'E' > 'A', 'B', 'F' > 'C', 'D', NULL > But I need this: > 'A', 'B', 'E,F' > 'C', 'D', NULL > Can SQL help me in any way here ? or do I have to do it by programming ?
If you use MySQL 4.1 or later take a look at http://dev.mysql.com/doc/mysql/en/group-by-functions.html and read the part about GROUP_CONCAT()... Regards, Jigal. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
