To merge the result set of two or more SELECT statements, use the UNION operator.

Within UNION, all SELECT statements must have an identical number of columns.

Additionally, the columns’ data types must be comparable. Every SELECT statement’s columns must be in the same order.