Group by with multiple results

[t_machine]

hi, how would I group in a table but display the rest of the result for each.

example:

username  |  groupmembership

sam          |        2
jessica      |        5
sam          |        7
paul          |        5


how can i group username but display all the groupmembership that they are in? As you can see "sam" is in the table twice but in two different groupmembership.

Thanks :)

[gluck]

post the details of the table

[fenway]

That depends on what you want back -- you could use a GROUP_CONCAT(), or use a subquery to get the groups, and then pull back details.

[t_machine]

Thank you both :) Yeah, I decided to run a sub query to get back all the groups data.