Each result set being pasted together must return the same number of columns
The corresponding columns in each result set must have compatible (if not Identical) data types
The column names in the final result set are taken from the first SELECT clause