Cross joins are one of the three fundamental types of joins: cross, inner and outer. There are also joins of the following types: self, equi and nonequi. Of the three fundamental types of joins, cross joins are the simplest, although less commonly used.

A cross join produces a Cartesian product of the two input tables. If one table contains M rows and the other contains N rows you get a result with M x N rows.