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.