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 e.last_name, d.department_name, d.location_id FROM employees e,
departments D WHERE e.department_id =d.department_id;
B.
SELECT last_name, department_name, location_id FROM employees , departments ;
C.
SELECT employees.last_name, departments.department_name,
departments.location_id FROM employees e, departments D WHERE e.department_id
=d.department_id;
D.
SELECT e.last_name, d.department_name, d.location_id FROM employees e,
departments D WHERE manager_id =manager_id;
Explanation: