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.
 
Back
Top