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

 

Example:

SELECT * FROM testtable
UNION ALL
SELECT * FROM testtable1