UNION

The UNION statement is used to combine result tables from two or more SELECT statements.

The general syntax is

    SELECT ...
    UNION 
    SELECT ...