Using A Table as <> Criteria

[realstandman]

Ok, I need to use a table of email address's to not be included on a query sort of like

[Bad_Email].[Bad_Email]<>[ConsentMaster].[member_email_address]

Below is the query I need to have this work with. I have tried every variation possible. Any help or tips will be greatly appreciated.


SELECT DISTINCT [ConsentMaster].[ccompany], [ConsentMaster].[cparent_group], [ConsentMaster].[cgroup], [ConsentMaster].[member_social_security_number], [ConsentMaster].[member_last_name], [ConsentMaster].[member_first_name], [ConsentMaster].[member_email_address]
FROM ConsentMaster INNER JOIN Consentqry2 ON ([ConsentMaster].[member_social_security_number]=[Consentqry2].[member_social_security_number]) AND ([ConsentMaster].[Date Stamp]=[Consentqry2].[Max Date])
WHERE ((([ConsentMaster].[member_email_address]) Like ("*@*.*") And ([ConsentMaster].[member_email_address]) Is Not Null) And (([ConsentMaster].[Consent])="y"));

 

[PHV]

Something like this ?
WHERE [ConsentMaster].[member_email_address] Like '*@*.*' And [ConsentMaster].[member_email_address] Is Not Null And [ConsentMaster].[Consent]='y'
And [ConsentMaster].[member_email_address] Not In (SELECT Bad_Email FROM Bad_Email);

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[realstandman]

Yep, that did it!!

Thanks Alot, You are truly the man!