CROSS JOIN

CROSS JOIN takes the Cartesian product—that is, all combinations of each table in the join.

Syntax

table1 CROSS JOIN table2

Example

SELECT *

FROM city CROSS JOIN attraction;

If city has 4 rows and attraction has 5 rows, CROSS JOIN returns 20 rows.