The query expression algorithms can be broken into the following categories:
Except algorithms, which include Except Merge and Except Hash
Intersect algorithms, which include Intersect Merge and Intersect Hash
Union algorithms, which include Union, Union All, and Recursive Union
Except algorithms
Intersect algorithms
Recursive Table algorithm
Recursive Union algorithm
RowReplicate algorithm
Union All algorithm