[Solved] Find the mistake in this query:SELECT * FROM Orders INNER JOIN Customers ON Orders.CustomerID = Customers.ID AND Customers.Region = 'East' OR Customers.Region = 'West'; | SQL

SQL - INNER JOIN

Find the mistake in this query:

SELECT * FROM Orders INNER JOIN Customers ON Orders.CustomerID = Customers.ID AND Customers.Region = 'East' OR Customers.Region = 'West';

AIncorrect use of OR without parentheses causing wrong join logic

BMissing JOIN keyword

CUsing WHERE instead of ON for join conditions

DNo mistake, query is correct

Step-by-Step Solution

Solution:

Step 1: Analyze join condition logic
AND and OR without parentheses can cause unexpected evaluation order.
Step 2: Identify logical error
OR should be grouped with parentheses to apply correctly to join conditions.
Final Answer:
Incorrect use of OR without parentheses causing wrong join logic -> Option A
Quick Check:
Use parentheses to clarify AND/OR in join conditions [OK]

Quick Trick: Use parentheses to group AND/OR in ON clause [OK]

Common Mistakes:

MISTAKES

Master "INNER JOIN" in SQL

9 interactive learning modes - each teaches the same concept differently

More SQL Quizzes

Find the mistake in this query: