ID CampaignId Query ---------------------------------------------------------------------------------------------------------------------------- 425 140 [Assembly]='151' AND [Party]='R' AND [Propensity]='4' 429 140 [Assembly]='151' AND [Party]='R' AND [Propensity]='3' 430 140 [Assembly]='151' AND [Party]='R' AND [Propensity]='2'So I now need to run a query that returns a DS of voters who match these queryies:
SELECT VoterID FROM tblCamp_CT WHERE [Assembly]='151' AND [Party]='R' AND [Propensity]='2'except the WHERE clauses come from the CompassQueries table for all rows that match the campaign.