DavidSzczesniak
1/24/2018 - 12:06 PM

UNION

This allows us to join the data in both tables into one, bigger table.

union.sql
content_copyfile_download
\!h Format: 
SELECT *
 FROM table1
 UNION
 SELECT *
 FROM table2;
 
\!h Rules:
-- Both tables must have the same number of columns.
-- The columns themselves must have the same data type, in the same order as the first table.

\!h UNION ALL to keep duplicates values
SELECT column_name(s) FROM table1
UNION ALL
SELECT column_name(s) FROM table2;