I am trying to do the following. I have a table called Customer and then I have a table called CustomerGroup 1 to Many to Customer. The fields for example are as follows:
Fields: CustId, CustName, CustAddress
Fields: CustId, GroupName
I want to get all the fields from table Customer then I want a comma seperated string of all the GroupNames from CustomerGroup stripped off end comma. How can I do this? Sample data:
CustAddress 12 Water St
Record would return
1, ABC, 12 Water St, 'A,B,C'