same group name field value join by , in sql server query

Question

Hi Guys,

I have one 'DataTable' and I want to Data like in 'ResultTable' using Sql Query so , I want that Query if U have Ans. then Reply me.

'Data Table'

MemberID	MemberName	FruitName
1	A1	Apple
1	A1	Orange

'Result Table'

MemberID	MemberName	FruitName
1	A1	Apple, Orange

Thanks........

Pnkl Patel