SQL Join Algorithm

SQL joins return subsets of all possible pairs of rows between two tables and rows of nulls. Note that subsets can be defined by inequalities as well as equalities.