Using the Union relational operator enables you to join information from two or more tables that have the same structure. Duplicate rows are eliminated.

 

Example:

SELECT * FROM testtable
UNION
SELECT * FROM testtable1