Hope anyone can help me here.
This is an example situation:
Table PetOwner
Peter Cat
Peter Dog
This is the table that i want to generate a query from. But i want the query to return results in this order if i wanted to find what pets Peter owned:
Generated results from SQL query
Peter Cat Dog
I.e. Instead of 2 records returned I want a single record returned with all pets associated with Peter returned in columns and not as individual rows.
Can anyone help this poor chap here?