Exclude Data

[bdjb]

Hello
I have two tables in a query, one has my data, the other have a list of data I want to exclude (the main table has e-mail addresses etc, the exclude table has list of test e-mails etc). I have them joined on e-mail, but I'm not sure how to write the criteria to exclude everything from the one table? MS Access 2003.

Thanks in advance

 

[PWise]

Select Email.emailAddress
from tblEmail
left join Testemail
on Email.emailAddress=Testemail.emailAddress
Where Testemail.emailAddress is null

 

[bdjb]

Thanks for the help, that did it.