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?