Where join properties are NOT equal

[Gazzamuffin]

I have two tables with the same data fields. I have joined them by the primary key and now want to use the join to exclude all records that appear in both tables.

The 3 options to join the tables only deal with records where the join properties are the same but I want to return all data from the first table except where it matches data from the second table.

Am I making sense?

Cheers
G

 

[jebry]

Hi!

Instead of using the design view, click on new and in the box that pops up choose Find Unmatched Query Wizard.

hth
Jeff Bridgham
bridgham@purdue.edu

 

[Gazzamuffin]

That simple huh? Thanks for that.
G