Cartesian Join

A join of two relations that delivers a row for every possible combination of rows in the sources; implemented in SQL using the CROSS JOIN clause.