UNION with mismatched column names

Question

Accepted Answer

In any set operation, the result column names are taken from the first SELECT statement. The second SELECT's column names are ignored entirely - only the data values matter, not the names. Column types must still be compatible, but names do not need to match at all.