List:General Discussion« Previous MessageNext Message »
From:Brad Jahnke Date:August 14 2006 4:29pm
Subject:Re: Joining result sets into 1 row
View as plain text  
> 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


 

Thread
Joining result sets into 1 rowSteffan A. Cline14 Aug
  • Re: Joining result sets into 1 rowOw Mun Heng14 Aug
  • Re: Joining result sets into 1 rowBrent Baisley14 Aug
  • Re: Joining result sets into 1 rowBrad Jahnke14 Aug
Re: Joining result sets into 1 rowOw Mun Heng14 Aug