alternate for minus operator

[iceswimn]

in oracle there is a minus operator when comparing two tables two each other, in order to only see the differences between the tables. I know there is no minus operator in Access, however is there an alternative way of getting to the same result.

 

[jrbarnett]

Do a left outer join from one table to the other, then filter to show only fields with NULL values on the left hand side of the join.

John

 

[PHV]

Or simply follow the unmatched query wizard.

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244