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.
 
Excellent! Using Union ALL instead of just Union did the trick.
Thanks!
 
You must log in or register to reply here.

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

Union Query and Field Alias 7
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
Date Limit in Crosstab from 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

Back
Top