Set Operators (Transact-SQL)

SQL Server provides the following set operators. Set operators combine results from two or more queries into a single result set.