To create a report displaying employee last names, department names, and locations. Which query should you use to create an equi-join?
Answer options
A
department_id =
B
department_id; SELECT
C
last_name
D
department_name
E
location_id FROM employees e, departments d WHERE manager_id =manager_id; SELECT
F
last_name
G
department_name
H
location_id FROM employees e, departments d WHERE
I
department_id =
J
department_id; SELECT last_name, department_name, location_id FROM employees , departments ;
K
last_name
L
department_name
M
location_id FROM employees e, departments d WHERE
N
department_id =
O
department_id;
Correct answer: department_id =
Explanation
Refer to Database Management — 7. Joins & Subquery study materials.