Web Development

Ask something
Discussion Locked

SQL Select troubles

0 helpful
2 replies

by at_1973

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

I have a table that contains contact ID's and what group they are associted with. I am trying to grab all the contact ID's that have a group of '32', then take all those Contact ID's and grab their contact details from a different table.

GROUP_ASSIGNMENTS
groupType | ContactID

CONTACTS
ContactID | Name | Address | ETC

I would like to wrap this into a single statement, but I cannot figure the sytntax to accomplish this. My other alternative is to load the selected ContactID's into a temporary table and then go back and query Contacts table for each of the ID's in the temp table.

Any help would be greatly appreciated. Thanks!

2 replies

by locolobo

SELECT contacts.ContactID, contacts.Name, contacts.ETC
FROM contacts, group_assignments
WHERE contacts.ContactID = group_assignments.ContactID
and group_assignments.groupType = 32;

Not sure if I read it right.

This discussion is closed to new replies.