The set operators work on complete rows of queries, so the results of the queries must have the same column name and column order, and the types of columns must be compatible. There are the following ...