Unmatched data in query

[Danielf]

Hi,

I have two tables let say "A" and "B" . I would like to compare all the unmatched records in both tables

I know ( with the query wizard) how to find unmatched records but the problem is that the wizard gives only unmatched records in one direction and not in both directions.
With one query , it will give me the unmatched records from table "A" and with
another query it will give me the unmatched records of table "B". Is it possible to merge both queries so I can have in one query both results?

Thanks

Daniel

 

[Brianwarnock]

A Union query?

Brian

 

[Danielf]

A Union query?

Brian

I have tried but it gives many unmatched records twice

Daniel

 

[gemma-the-husky]

brian is correct

select * from UnmatchedQueryInOneDirection UNION
select * from UnmatchedQueryInOtherDirection

will not duplicate items.

 

[Danielf]

brian is correct

select * from UnmatchedQueryInOneDirection UNION
select * from UnmatchedQueryInOtherDirection

will not duplicate items.

Now I am receiving ( after having merged the 2 queries in one query)
the following error message :"The number of columns in the two selected tables or queries of a union query do not match"

What I don't understand is that the 2 queries are identical, the only difference is the direction. In the first one it goes from "A" to "B" and in the second one from "B" to "A"

Daniel