INTERSECT
Use INTERSECT to return only the rows that are in the results of both the first and second queries. Each selection must have the same data types.
Syntax
Select * from object1 INTERSECT
Select * from object2
Use INTERSECT to return only the rows that are in the results of both the first and second queries. Each selection must have the same data types.
Select * from object1 INTERSECT
Select * from object2