CROSS JOIN produces a cartesian product

Question

Accepted Answer

CROSS JOIN pairs every row in the left table with every row in the right table - no ON condition is needed or allowed. 2 colors x 2 sizes = 4 combinations: (Red, S), (Red, M), (Blue, S), (Blue, M). This is useful for generating all combinations, but can be catastrophic on large tables.