SQL UNION ALL

SQL UNION ALL is query that allows you to select related information from 2 tables, the result is different from the UNION statement. It return all the record from SELECT statement that used.

UNION ALL selects all rows from each table and combines them into a single table.

The syntax is as follows:

SELECT [COLUMN NAME 1], [COLUMN NAME 2],… FROM [TABLE NAME 1]
UNION ALL
SELECT [COLUMN NAME 1], [COLUMN NAME 2],… FROM [TABLE NAME 2]

EXAMPLE :

We have 2 table name GamesScores, GameScores_new.

Table GameScores

Table GameScores_new

SQL statement :

SELECT PlayerName FROM GameScores
UNION ALL
SELECT PlayerName FROM GameScores_new

Result: