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