-
Query Help
Hi,
I need help with writing a query to group the following data:
Name Fruit
----------- ---------
John Smith Apples
John Smith Oranges
John Smith Bananas
Mike Jones Apples
Mike Jones Kiwi
Mike Jones Grapes
Mike Jones Pears
I need it to look like this:
Name Fruit
----------- ---------
John Smith Apples, Oranges, Bananas
Mike Jones Apples, Kiwi, Grapes, Pears
Can someone please help me with this?
Thanks so much!
- Sammy
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
|
|