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.