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

Do a left join on the four fields and select  where the right field is 
null.

Select *
from staging s
left join customers c on
s.street = c.street,
s.no = c.no,
s.city = c.city,
s.zipcode = c.zipcode
where c.street is null

On 20 Dec 2006 at 2:01, Sad Der wrote:

> 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 
> -- 
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com

-- 
Stuart