csharpmin Posted March 24, 2011 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?
comment Posted March 24, 2011 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.
Recommended Posts
This topic is 5053 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