>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.
Greg Reichert