Is there a way to use a string concatenating function in connection with a GROUP BY clause? I mean, for a one-to-many relation (like firm-stockholders relation), to "catch" a structure like:
firm | stocholders -------------------- f_1 | s_1; s_2; s_3 f_2 | s_4; s_5 f_3 | s_6 instead of firm | stocholders -------------------- f_1 | s_1 f_1 | s_2 f_1 | s_3 f_2 | s_4 f_2 | s_5 f_3 | s_6 -- Cip -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
