csharpmin Posted March 24, 2011 Share Posted March 24, 2011 I have a contact/organizations database, and I want to list the contact's co-workers. More specifically, on the contact page, I want to list all the contacts who are members of the organization of which the current contact is a member. But I don't want to list the current contact in the list, just the coworkers. I have no problem showing all members of the organization, but I don't want to list the current contact. My relationship involves 3 tables Contacts, Org_Members, and Organizations primary IDs in the Contacts and Orgs tables equal the secondary IDs the Org_members table. Is a self-join somehow the answer? Link to comment Share on other sites More sharing options...
comment Posted March 24, 2011 Share Posted March 24, 2011 I want to list all the contacts who are members of the organization of which the current contact is a member. Did you mean organizations (plural)? From your structure it's obvious a contact can be member of more than one. Link to comment Share on other sites More sharing options...
Recommended Posts
This topic is 4775 days old. Please don't post here. Open a new topic instead.
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now