Unmatched Query

[Guest]

I have created an unmatched query using the wizard.
However I wanted the query to check more than one field
before returning the unmatched records?

Any ideas?

 

[Allen Browne]

The unmatched query wizard generates an outer join query where the foreign
key is null.

If you want extra fields in the join, you can drag them from one table to
the other. Then double-click the join lines, and choose the option that
gives you the arrow heads pointing in the same direction.