Union

SQL Unions #

Stack data on top of each other.

Union #

Concatenates records, drops duplicates.

For instance, when there are similar columns/fields across two tables, and same data types:

SELECT <fields>
FROM <table_1>
UNION
SELECT <fields>
FROM <table_2>;

Union All #

Concatenates records, keeps duplicates.