[Solved] Identify the error in this SQL query:SELECT * FROM Products INNER JOIN Suppliers ON Products.SupplierID = Suppliers.ID, Products.Category = Suppliers.Category; | SQL

SQL - INNER JOIN

Identify the error in this SQL query:

SELECT * FROM Products INNER JOIN Suppliers ON Products.SupplierID = Suppliers.ID, Products.Category = Suppliers.Category;

AUsing ON instead of WHERE for join conditions.

BMissing WHERE clause for the second condition.

CUsing comma instead of AND to combine join conditions.

DINNER JOIN cannot have multiple conditions.

Step-by-Step Solution

Solution:

Step 1: Review JOIN condition syntax
Multiple join conditions must be combined with AND inside the ON clause.
Step 2: Identify the error in the query
The query incorrectly uses a comma to separate conditions, which is invalid syntax.
Final Answer:
Using comma instead of AND to combine join conditions. -> Option C
Quick Check:
Multiple conditions joined by AND, not comma [OK]

Quick Trick: Use AND, not comma, to join multiple ON conditions [OK]

Common Mistakes:

MISTAKES

Master "INNER JOIN" in SQL

9 interactive learning modes - each teaches the same concept differently

More SQL Quizzes

Identify the error in this SQL query: