UNION, INTERSECT and EXCEPT operators are commonly called Set Operators. For example, in Books Online you can find a topic “ Set Operators ”, where these three operators are explained. They should represent set operations UNION, INTERSECT and MINUS
Read More...