Learn From - Interactive SQL

The UNION is used to merge two or more tables having the same column names.

The Select statements used should have the same column names and the column names should be retrieved in the same order. Also the datatype for the columns should be the same in both the tables.

SQL UNION Syntax

Note: The executed result will show only distinct values only. To get duplicate values you need to use UNION ALL keyword.

SQL UNION ALL Syntax

Note: The executed result will show all the duplicate values.

Below is shown the "Customers_USA" table:


Below is shown the "Customers_Australia" table:

SQL UNION Example

To merge tables with records from Customers_USA and Customers_Australia. All the unique records from both the tables are retrieved.

Text Editor below has the SQL Query, click the "View Result" button, to see the result.


Note: The executed result contains only 6 records.

To merge tables with records from Customers_USA and Customers_Australia. The Executed Result will contain only Unique Records.


Note: The Executed Result contains only 8 records

SQL in Text Editor:

Select Customers_USA.CustomerName, Customers_USA.EmailID from Customers_USA UNION Select Customers_Australia.CustomerName, Customers_Australia.EmailID from Customers_Australia