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
EMAIL, USERNAME
email1, user1
email1, user2
email2, user1
email3, user1
email3, user2
I want to do a select with a subquery? to get the following format.
EMAIL, USERNAME
email1, user1 user2
email2, user1
email3, user1 user2
Any pointers or help very much appreciated, i'm definitely rusty in sql