Dear Group,

I need your help with the following issue:

I have one table which stores names and ids like:

TABLE names
NameID, Name, CreationDate etc.

and I have the MEMBERS table which stores multiple membernames attached to a single name like

TABLE members
NameID, MemberID, MemberName etc.

I'd like a query, which returns multiple names with the given IDs and all the membernames that are attached to it.

How do I write an SQL for this? So the result of the query should be like:
NameID1, Name1, 'MemberName1, MemberName2, MemberName3, etc.'
NameID2, Name2, 'MemberName4, MemberName5, etc.'
...

Thanks for your help!

Zd

[Non-text portions of this message have been removed]