Not Distinct in a UNION query

I'm stitching together QUERY1 and QUERY2  with a UNION query (QUERY3).
In QUERY1 there are several identical records.
After the UNION several records have been left out, and there are now no identical records.

How can I fix this?

Arild
LVL 2
arildj78Asked:
Who is Participating?
 
nico5038Connect With a Mentor Commented:
Hmm should learn t type better, the query should be:
select * from query1
UNION ALL
select * from query2;

A "normal" UNION will sort the rows and eliminate the duplicates.

Nic;o)
0
 
nico5038Commented:
Try:

select * formquery1
UNION ALL
select * from query 2

Nic;o)
0
 
Pigster14Connect With a Mentor IT ConsultantCommented:
Try UNION ALL instead
0
 
arildj78Author Commented:
That did it :)   Thanks
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.