INTERSECT and EXCEPT

The previous chapter covered stacking rows from multiple queries. But sometimes you don't want to combine everything. You want to know which rows appear in both result sets, or which rows appear in one but not the other.

That's what INTERSECT and EXCEPT are for.