CROSS JOIN
Intermediate
A T-shirt shop wants a list of every variant it could stock: each color in each size.
Write a query returning every combination of a row from colors and a row from sizes, with the columns color and size.
Constraints
- Columns, in order:
color,size - Every color paired with every size (2 × 3 = 6 rows here)
Hints
Hint 1
A cross join needs no ON condition.
Hint 2
Alias both name columns, since both tables have one.
Keywords
db
SQL
Run your code to see results
No results yet
Run your code to check it against the examples, or submit to run every test.