Can a Query show records between 2 tables that DO NOT match?

[Bob]

access 2k;

I have 2 tables joined 1 to 1 on a single key field

table B can have key values that are NOT in table A; these records
will not go into table A during an update.

is it possible to setup a query that will show me ONLY the records in
table B that do not have a matching counter-part in table A?

tia - Bob

 

[Gary Wheeler]

-----Original Message-----
access 2k;

Yes the SQL syntax is

Select B.*
From b left outer join A On (b.keyvalue = a.keyvalue)
Where a.keyvalue is null


If you plug in your table names and the actual fields you
can paste this into a access query SQL section and it
should work for you.

Gary

 

[Bob]

Gary -
tx very much for your reply...

I probably should have checked on the sql syntax 1st...

I keep forgetting how the "design view" really doesn't accomodate the
actual capabilities of SQL.

tx again - Bob