UNION vs UNION ALL
UNION The UNION command combines the result set of two or more SELECT statements (only distinct values). UNION ALL The UNION ALL command combines the result set of two or more SELECT statements (allows duplicate values).
Remove Duplicate Record
Look for duplicate records. Remove duplicate records