In the query SELECT e.name FROM employees e INNER JOIN departments d ON e.dept_id = d.id;, what do e and d represent?

easy📝 Conceptual Q2 of 15

SQL - INNER JOIN

In the query SELECT e.name FROM employees e INNER JOIN departments d ON e.dept_id = d.id;, what do e and d represent?

AColumn aliases

BTable aliases

CDatabase names

DFunction names

Step-by-Step Solution

Solution:

Step 1: Identify aliases in the query
The letters e and d follow table names and are used to shorten references.
Step 2: Determine alias type
Since they refer to tables employees and departments, they are table aliases.
Final Answer:
Table aliases -> Option B
Quick Check:
Aliases after table names = Table aliases [OK]

Quick Trick: Aliases after table names are table aliases [OK]

Common Mistakes:

MISTAKES

Master "INNER JOIN" in SQL

9 interactive learning modes - each teaches the same concept differently

Want More Practice?

15+ quiz questions · All difficulty levels · Free

More SQL Quizzes