>>Hi
>>
>>I've got a member table, a contact table and an organisation table.
>>
>>
>>A member is part of an organisation via a linking contact table and should only be a member of one organisation.
>>
>>I want to list members who are members of more than one organisation and on the same line have the organisation code.
>>
>>So
>>
>>member001,ORG01,ORG02
>>member002,ORG01,ORG06,ORG08
>>
>>etc
>>
>>Any thoughts on the best way to produce this would be welcome.
>
>If your version of SQL supports it, check out the PIVOT clause.

Thanks Greg

I did have quick look at that but I don't want to predefine the columns for groups (there are several hundred) I just want to list out what groups a members is part of