Alternative to SQL UNION Query 1

[jamie81]

I have two queries that I need to combine into one query using a sql statement. A UNION query would work like a charm, except that it automatically eliminates any rows with duplicate data.

How do I combine the results of two queries, based on matching columns, without deleting duplicate data?

 

[JoeMiller]

Add the ALL keyword:

SELECT * FROM Yin
UNION ALL
SELECT * FROM Yang


Joe Miller
joe.miller@flotech.net

 

[JoeMiller]

grrrrr.... try this instead


SELECT * FROM Yin
UNION ALL
SELECT * FROM Yang Joe Miller
joe.miller@flotech.net

 

[jamie81]

That worked! Thank you very much!