Cross join for combinations

Cross join for combinations

Easy SQL Joins 14 views
Explanation Complexity

Problem Statement

Create all combinations of Sizes(s) and Colors(c) to generate SKU options.

Input Format

SQL query

Output Format

Result set

Example

Sizes(size), Colors(color)
All combinations

Constraints

None

Input / Output Format

Input Format
SQL query
Output Format
Result set
Constraints
None

Examples

Input:
Sizes(size), Colors(color)
Output:
All combinations

Example Solution (Public)

SQL 
SELECT s.size, c.color FROM Sizes s CROSS JOIN Colors c;

Official Solution Code

SELECT s.size, c.color FROM Sizes s CROSS JOIN Colors c;
Please login to submit solutions.
Editor
Output

                                        

                                    

                                    

                                        

                                                                                    
Please login to submit solutions.