CROSS JOIN

Every join type we have covered so far uses an ON condition to match rows. CROSS JOIN is different. It has no matching condition at all. It pairs every row from the left table with every row from the right table, producing a Cartesian product. If the left table has 4 rows and the right table has 5 rows, the result has 20 rows.