0

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

2
Contributors
2
Replies
3
Views
7 Years
Discussion Span
Last Post by litlemaster
0

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.

0

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

This question has already been answered. Start a new discussion instead.
Have something to contribute to this discussion? Please be thoughtful, detailed and courteous, and be sure to adhere to our posting rules.