How many rows does this return?
-- sizes has 3 rows, colors has 4 rows SELECT * FROM sizes CROSS JOIN colors;
- 12
- 16
- 7
- 10
A
Play SQL & Databases ▸
CROSS JOIN is a Cartesian product: every size pairs with every color, 3 x 4 = 12.