Fewer records after UNION?

  • Thread starter Thread starter NerdRunner
  • Start date Start date
N

NerdRunner

I am using Union to bring two tables together. Before the union, one
query has 1500 results and the other 97. After the union I have only
1350 results. I should have 1597. What could be the reasons behind
receiving fewer records after a union than what each of the union
members have before the union?

Sean M. Severson
 
UINION eliminates duplicates.

Try using UNION ALL instead, and see whether you get 1597.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Query is too complex 5
getting fewer records from a union query than in individual table 5
How to assign table name to be value of a field in a UNION query? 2
Run Make Table Query on Union Query 2
Union Query to list duplicates 2
Losing Records Between Union Query and Select Query 3
Union Query Removing records 4
Union Query 2

Back
Top