Query Match/Merge

[Guest]

I have two Queries that have the same structure. I want to MATCH / MERGE the two creating a third one of records equal grouped items, rejecting the non-equal.

 

[John Spencer (MVP)]

Put the two queries into a third query and join on the fields that should match.
If you have too many fields to join on all of them, you can join on as many as
possible and then use the where clause to finish the match.

SELECT A.*
FROM TableOne as A INNER JOIN TableTwo as B
ON A.Field1 = B.Field1 AND
A.Field2 = B.Field2 AND
...
WHERE A.Field11 = B.Field11 AND
A.Field12 = B.Field12 AND
...