General discussion
-
Topic
-
SQL Select troubles
LockedI 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 | ContactIDCONTACTS
ContactID | Name | Address | ETCI 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!
All Comments
Viewing 0 reply threads