[AccessD] Query => values not in...

Sad Der accessd666 at yahoo.com
Wed Dec 20 04:01:06 CST 2006


Hi group,

i've got 2 tables
Customers
Staging

Both have fields:
street
no
city
zipcode

I need the following results:
Get all records from table Staging where (street, no, city, zipcode) not in (select street, no, city, zipcode from Customers)

So if the combination of "street, no, city, zipcode" in the table staging is not in the table Customers I want to see that record/ those records
How do I do this in Access SQL???

TIA

Sander

__________________________________________________
Do You Yahoo!?
Tired of spam?  Yahoo! Mail has the best spam protection around 
http://mail.yahoo.com 



More information about the AccessD mailing list