Union all query

[kowol]

Hello,
I'd like to use Union All to join the data from two table.
But I've found a couple of records from each table have exactly same data.
How to join the table to show all the data from two table including duplicates.

 

[Pat Hartman]

UNION ALL includes all rows. I'm not sure what the problem is. UNION will eliminate duplicates and UNION ALL will keep them.