How to Find Unmatched recored between two table

[mks123]

Hi All,



I'm trying to build query to extract unmatched records between two table by considering 4field.

I know how to do get unmatched records for 1 field ----- Select statement with Not IN opt


I can do by creating unique Id merging 4 field then above method, but Is there other way?


here is info I have.

Table A - F1 , F2 F3 F4

Table B - F1 , F2 F3 F4


Any help would be much appreciated.


Regards,
Mukesh

[ranman256]

OUTER join will show you what is missing in 1 table yet in the other.

[mks123]

can you show me.

[rdougherty]

I typically create a temp field on the table with less data, and then run an update query marking all of the matches, and then export all of the non-matches via a new query. there might be a better, more concise way.

[JoeM]

Simply use the Unmatched Query Wizard. It will only do it on a single join field, but after it is complete, simply open up the Query in Design View, and manually join the other three fields by clicking and dragging them from one table to the other. Make sure that the arrows on those joins are pointing in the same direction as the original join that was set up. If they aren't, simply double click on the line and change the join (if it is on the 2nd option, change it to the 3rd; if it is on the 3rd option, change it to the 2nd).