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 …]

See Also

SELECT