UNION ALL

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