SELECT position, GROUP_CONCAT( name ) FROM `position_names` GROUP BY position
Justin Scott Giboney On Thu, Nov 4, 2010 at 10:08 AM, Merrill Oveson <[email protected]> wrote: > Suppose I have the following table > > Position Name > ------------|----------- > 1 Jim > 1 Bob > 1 Amy > 2 Mary > 2 Karen > > > What I'd like is a query that will produce the following output > > Position Name > ------------|----------- > 1 Amy Bob Jim > 2 Karen Mary > > > Is there a relatively simple way to do this? > > Merrill > > _______________________________________________ > > UPHPU mailing list > [email protected] > http://uphpu.org/mailman/listinfo/uphpu > IRC: #uphpu on irc.freenode.net > _______________________________________________ UPHPU mailing list [email protected] http://uphpu.org/mailman/listinfo/uphpu IRC: #uphpu on irc.freenode.net
