INTERSECT

A relational operator that returns the intersection of two sets. A INTERSECT B returns those rows that are in both A and B.