Query language processor

The Union operator combines the results of two or more queries into a distinct single result set that includes all the rows that belong to all queries in the Union.

To display all the rows of data from table 1 and table 2 with out overlaying coloums .

The UNION operator is used to combine the result set of two more select statement.