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]
We have 2 table name GamesScores, GameScores_new.
SQL statement :
SELECT PlayerName FROM GameScores