Cross Join Combinations — Solution & ExplanationProblems / Cross Join Combinations / EditorialApproach

CROSS JOIN colors with sizes. No join condition is needed — every color is paired with every size.

Select just the name columns.

Order by color_name, then size_name.

Key InsightCROSS JOIN is useful for generating all combinations. The result size is |left| × |right|. Use it sparingly on large tables since it can produce very large outputs.Hints

A CROSS JOIN produces the Cartesian product — every row in the left table paired with every row in the right.

With 5 colors and 4 sizes, expect 20 rows in the output.

CROSS JOIN has no ON clause.

Solve Cross Join Combinations yourself →