The UNION operator is used to combine the result-set of two or more SELECT statements.
- Each SELECT statement within the UNION must have the exact same number of columns
- The columns must also have similar data types.
- The columns in each SELECT statement must be in the exact same order.
SELECT column_name(s) FROM table1
SELECT column_name(s) FROM table2;