Merge, intersect, and subtract result sets with UNION, INTERSECT, and EXCEPT.
UNION & UNION ALL
Stack two query results into one — with or without deduplication
INTERSECT
Find rows that appear in both query results
EXCEPT
Find rows in the first result that don't appear in the second