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!
