How About Union Operation?

Question

To perform a union operation columns in inquiries must be the same

Answer 1

For union or union all operations you must have same numbers of columns in queries and also the data type should match, unless you explicitly cast it to some other type union will you the unique data

Answer 2

For Union operation, number of columns must be the same and the data type also should be the same for the tables which we are performing union and Union All.