ok, this is a real simple one, i could probably do it if i knew what to search for
i have a table with 2 columns, Email and Username
The data looks like this
I want to do a select with a subquery? to get the following format.
email1, user1 user2
email3, user1 user2
Any pointers or help very much appreciated, i'm definitely rusty in sql