Selecting records with no match in second table

[sevex]

I've seen this done so many times, and now I can't remember how it's done.

I have two tables, linked with a common field, and I want to select everything from the first table that doesn't have any matching records in the second table.

A quick example would be greatly appreciated. Thanks in advance.

 

[cmmrfrds]

Left or Right outer join.

select name from table1
left outer join table2
on table1.key = table2.key

 

[lblastick]

Or you could create a 'Find Unmatched' query. I find using the wizard makes it less confusing. Hope it helps

 

[WildHare]

You might find this useful:

http://www.jmhare.com/joins.htm

or a FAQ here: faq700-1681

78.5% of all statistics are made up on the spot.
Another free Access forum:

http://www.forumco.com/jmhare

More Access stuff at

http://www.jmhare.com/wildhare2.htm

 

[sevex]

thanks for the help, but I gave up and took an easier path. just selected all of the records, matching and all, then used code to check for the unmatched ones.