[Solved] Find the issue in this self join query:SELECT e1.name, e2.name FROM employees e1, employees e2 WHERE e1.manager_id = e2.id; | SQL

SQL - INNER JOIN

Find the issue in this self join query:

SELECT e1.name, e2.name FROM employees e1, employees e2 WHERE e1.manager_id = e2.id;

AUsing comma join instead of explicit JOIN

BMissing explicit JOIN keyword

CNo aliasing of tables

DIncorrect join condition

Step-by-Step Solution

Solution:

Step 1: Identify join style used
The query uses comma-separated tables with WHERE clause, which is an old-style join.
Step 2: Recognize best practice
Explicit JOIN syntax is preferred for clarity and maintainability.
Final Answer:
Using comma join instead of explicit JOIN -> Option A
Quick Check:
Use explicit JOIN, not comma join [OK]

Quick Trick: Prefer explicit JOIN over comma joins [OK]

Common Mistakes:

MISTAKES

Master "INNER JOIN" in SQL

9 interactive learning modes - each teaches the same concept differently

More SQL Quizzes

Find the issue in this self join query: