SQL - Subqueries
Identify the error in this SQL query that uses a JOIN:
SELECT c.name, o.amount FROM customers c JOIN orders o WHERE c.id = o.customer_id;
Identify the error in this SQL query that uses a JOIN:
medium📝 Debug Q14 of 15
Step-by-Step Solution
Solution:
Step 1: Review JOIN syntax
JOIN requires an ON clause to specify join condition, not WHERE.Step 2: Check the query
The query uses WHERE for join condition, which is incorrect syntax for explicit JOIN.Final Answer:
Missing ON keyword before join condition. -> Option CQuick Check:
JOIN needs ON, not WHERE [OK]
Quick Trick: JOIN must have ON clause for conditions [OK]
Common Mistakes:
MISTAKES- Using WHERE instead of ON for JOIN
- Confusing HAVING with WHERE
- Assuming aliases cause error
Master "Subqueries" in SQL
Want More Practice?
15+ quiz questions · All difficulty levels · Free
Free Signup - Practice All QuestionsMore SQL Quizzes