Combine Result Sets

Set operations combine two SELECT results with matching column counts and compatible types. UNION removes duplicates, UNION ALL keeps them, INTERSECT keeps common rows, and EXCEPT keeps left-only rows.