SQL: JOINS - UNION

UNION

The UNION operator combines result sets of two or more SELECT statements into a single result set.

Syntax:

-- UNION
SELECT column_1, column_2
FROM table_name_1
UNION
SELECT column_1, column_2
FROM table_name_2;