CROSS JOIN

Cross joins are also called Cartesian products. In a cross join, every row in the left table is returned, and each of these rows is combined with all the rows from the right table. If the left table has 10 rows and the right table 100 rows, then the cross join produces 1000 rows.