Stuart McLachlan
stuart at lexacorp.com.pg
Wed Dec 20 04:37:07 CST 2006
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