[Solved] Identify the error in this SQL query:SELECT a.name, b.salary FROM Employees a JOIN Salaries b WHERE a.id = b.emp_id; | SQL

SQL - INNER JOIN

Identify the error in this SQL query:

SELECT a.name, b.salary FROM Employees a JOIN Salaries b WHERE a.id = b.emp_id;

AUsing alias names incorrectly

BMissing ON keyword before join condition

CSELECT clause syntax is wrong

DJOIN cannot be used with WHERE clause

Step-by-Step Solution

Solution:

Step 1: Check JOIN syntax
JOIN requires ON keyword to specify the join condition, not WHERE.
Step 2: Identify the error
The condition 'a.id = b.emp_id' should be after ON, not in WHERE.
Final Answer:
Missing ON keyword before join condition -> Option B
Quick Check:
JOIN condition needs ON, not WHERE [OK]

Quick Trick: Use ON for JOIN conditions, not WHERE [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: