(Derek E Wilson) Set operators allow you to combine data from two or more queries and return the results in a single set. There are 3 set operators available T-SQL EXCEPT, INTERSECT and UNION.
Read More - Register for Free Membership
SQL Server, Azure SQL Database, Amazon RDS & AWS, Oracle and IBM Help