The rows returned by the #SQL set operators are UNION All from both tables MINUS/EXCEPT Those in the first table not in the second INTERSECT Rows that are the same in both tables By default, these de-duplicate rows. The ALL clause preserves and accounts for duplicate rows