I have three as
1.Contacts --> contact_ID, contact_name
2.Members --> contact_ID, Group_ID
3.Groups --> group_ID, contact_ID
I want to SELECT contacts_names from Contacts where some Group_ID such that all the contact_IDs belong to one group_ID in table Members.
In short I want to Group my contacts. Please Help
Two things...
1) Is there a typo in your Groups table? You have Group_ID and Contact_ID, which is a duplicate of the Members table.
2) I showed you how to construct a select query to limit returned rows by group in your other thread.
yes, I have resolved it In that way, I started a new thread as It was going off topic from that thread. Thank you very much
We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.