Which query should you use to create an equi-join?

Examine the structure of the EMPLOYEES and DEPARTMENTS tables:

You want to create a report displaying employee last names, department names, and locations.
Which query should you use to create an equi-join?

A.
SELECT last_name, department_name, location_id
FROM employees , departments ;

B.
SELECT employees.last_name, departments.department_name, departments.location_id
FROM employees e, departments D
WHERE e.department_id =d.department_id;

C.
SELECT e.last_name, d.department_name, d.location_id
FROM employees e, departments D
WHERE manager_id =manager_id;

D.
SELECT e.last_name, d.department_name, d.location_id
FROM employees e, departments D
WHERE e.department_id =d.department_id;

Explanation:
Equijoins are also called simple joins or inner joins. Equijoin involve primary key and foreign key.
Incorrect answer:
Athere is no join
B invalid syntax
Cdoes not involve the join in the primary and foreign key
Refer: Introduction to Oracle9i: SQL, Oracle University Study Guide, 4-8