> I want to have the rows returned as one row
> Such as 
> ROW 1 Mechanic, Carpenter, Plumber

You may want to try GROUP_CONCAT(expr)  ...

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


 


-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]

Reply via email to