SQL Statements › SELECT › Description › Rules for Columns
Result tables R1 and R2 must have the same number of columns.
When UNION is performed, the corresponding columns of the SELECT lists need to be compatible data types.