UNION

Transact-SQL Reference

Transact-SQL Reference

UNION

Combines the results of two or more queries into a single result set consisting of all the rows belonging to all queries in the union. For more information, see SELECT.