General information
Forum:
Microsoft SQL Server
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.
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only