UNION ALL query

[bbulla]

OK, so I am UNIONing two tables using UNION ALL. It works fine. The resultant table has 192 records (63 + 129).

If a use just UNION or UNION DISTINCT I get 184 records. I'm pretty sure that is telling me that 8 records (192 - 184) exist in both tables.

How do I query to find out what those 8 records are?? I'm trying to use an INTERSECT in MS Access, but it doesn't want to work. Here is my original query:

select * from qryMOE_Active_All
UNION ALL select * from qryMOE_Closed_All;

Thanks,

Brian

 

[FoFa]

The queries your UNION query is based on must be selecting duplicate records (DAH). But if the data is suppose to be different, how can that be?
INTERSECT, we just had a thread on that last week. You didn't use search did you.

 

[bbulla]

Pat: Thanks! A 'Find Duplicates' on my Union query. Why didn't I think of that.

FoFa: Actually, I did use search, but it didn't answer my question.