Solution:Step 1: Use CROSS JOIN to get all combinationsUse CROSS JOIN between Products and Colors to get every product-color pair.Step 2: Filter out discontinued productsApply WHERE clause to keep only products where discontinued = FALSE.Step 3: Check other options for errorsSELECT p.name, c.color F

[Solved] You have two tables:Products with 4 rows and Colors with 5 rows.You want to generate a list of all product-color combinations but exclude combinations where the product is discontinued.... | SQL

SQL - Advanced Joins

You have two tables:
Products with 4 rows and Colors with 5 rows.
You want to generate a list of all product-color combinations but exclude combinations where the product is discontinued.
Which query correctly uses CROSS JOIN and filtering?

ASELECT p.name, c.color FROM Products p INNER JOIN Colors c ON p.discontinued = FALSE;

BSELECT p.name, c.color FROM Products p CROSS JOIN Colors c WHERE p.discontinued = FALSE;

CSELECT p.name, c.color FROM Products p CROSS JOIN Colors c ON p.discontinued = FALSE;

DSELECT p.name, c.color FROM Products p, Colors c WHERE p.discontinued = TRUE;

Step-by-Step Solution

Solution:

Step 1: Use CROSS JOIN to get all combinations
Use CROSS JOIN between Products and Colors to get every product-color pair.
Step 2: Filter out discontinued products
Apply WHERE clause to keep only products where discontinued = FALSE.
Step 3: Check other options for errors
SELECT p.name, c.color FROM Products p INNER JOIN Colors c ON p.discontinued = FALSE; uses INNER JOIN incorrectly with ON condition unrelated to join keys. SELECT p.name, c.color FROM Products p CROSS JOIN Colors c ON p.discontinued = FALSE; uses ON with CROSS JOIN, which is invalid syntax. SELECT p.name, c.color FROM Products p, Colors c WHERE p.discontinued = TRUE; filters discontinued = TRUE, opposite of requirement.
Final Answer:
SELECT p.name, c.color FROM Products p CROSS JOIN Colors c WHERE p.discontinued = FALSE; -> Option B
Quick Check:
CROSS JOIN + WHERE filters correctly [OK]

Quick Trick: Filter after CROSS JOIN with WHERE clause [OK]

Common Mistakes:

MISTAKES

Using ON clause with CROSS JOIN
Filtering with wrong discontinued value
Confusing INNER JOIN with CROSS JOIN usage

Master "Advanced Joins" in SQL

9 interactive learning modes - each teaches the same concept differently

Learn Why Deep Visual Try Challenge Project Recall Time

More SQL Quizzes

You have two tables:

Step 1: Use CROSS JOIN to get all combinations

Step 2: Filter out discontinued products

Step 3: Check other options for errors

Final Answer:

Quick Check:

Want More Practice?