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