Check out the GROUP_CONCAT() function, see if this help: http://dev.mysql.com/doc/mysql/en/GROUP-BY-Functions.html
Shawn Green Database Administrator Unimin Corporation - Spruce Pine "Feghhi, Jalil" <[EMAIL PROTECTED]> wrote on 10/05/2004 11:20:21 AM: > > Is there a way to convert the following result set: > > id f2 > --- --- > 1 b > 1 c > > to: > > id f2 > -- -- > 1 b,c > > Using a select or any other functions? Basically, I want to put f2 > fields together when ids are the same. > > Thanks, > > -Jalil > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] >
