SQLite CROSS JOIN clause

A SQLite CROSS JOIN is implicitly created by a SQLite SELECT statement if it is used to query data from two tables without any relations between the tables.

The SQLite CROSS JOIN results in the combinatino of all rows from the first table with all rows in the second. The CROSS JOIN clause produces a Cartesian JOIN, i.e. the Cartesian product.

Exemplary syntax:

FROM table1
CROSS JOIN tabel2;