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

PlayerNameDepartmentScores
JasonIT3000
IreneIT1500
JaneMarketing1000
DavidMarketing2500
PaulHR2000
JamesHR2000

Table GameScores_new

PlayerNameDepartmentScores
JasonIT3000
DavidMarketing2500
PaulHR2000
JamesHR2000

SQL statement :

SELECT PlayerName FROM GameScores
UNION ALL
SELECT PlayerName FROM GameScores_new

Result:

PlayerName
Jason
Irene
Jane
David
Paul
James
Jason
David
Paul
James