-
Help with SQL query!
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?
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|