Each query connected by UNION produces a set of rows. The union must include the same number of columns from each table in each SELECT statement and the data types of these columns must be compatible. The result sets are combined into a single result set that has the data type of the columns specified in the first SELECT statement in the union.