What is a UNION in SQL?

The UNION operator combines the result sets of two or more SELECT queries into a single

result set and removes duplicate records. All SELECT queries must have the same number

of columns with compatible data types.

Example:

SELECT Name FROM Employees

UNION

SELECT Name FROM Customers;