UNION ALL
Combines the result from multiple SELECT statements into a single result set. The result includes all matching rows from all the SELECT statements.
Syntax
SELECT ...
UNION ALL SELECT...
[UNION ALL SELECT …]Combines the result from multiple SELECT statements into a single result set. The result includes all matching rows from all the SELECT statements.
Syntax
SELECT ...
UNION ALL SELECT...
[UNION ALL SELECT …]