Microsoft introduced a new operator, INTERSECT, in SQL Server 2005.
INTERSECT returns any distinct values that are returned by both the query on the left and right sides of the INTERSECT operator.
INTERSECT Operator in SQL Server 2005
Модератор: onlinehelp