[Solved] Identify the error in this query:SELECT a.name, b.salary FROM employees a INNER JOIN salaries b ON a.emp_id = b.emp_id WHERE b.salary > 50000; | SQL

SQL - INNER JOIN

Identify the error in this query:

SELECT a.name, b.salary FROM employees a INNER JOIN salaries b ON a.emp_id = b.emp_id WHERE b.salary > 50000;

ANo error, query is correct

BIncorrect join condition syntax

CMissing table alias declaration

DUsing WHERE instead of ON for join

Step-by-Step Solution

Solution:

Step 1: Check alias usage
Aliases a and b are declared and used correctly.
Step 2: Verify join and filter syntax
Join condition uses ON properly; WHERE filters after join, which is correct.
Final Answer:
No error, query is correct -> Option A
Quick Check:
Correct alias and join syntax = No error [OK]

Quick Trick: Use ON for join, WHERE for filtering [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 query: