【单项选择题】
Examine the structure of the EMPLOYEES and DEPARTMENTS tables:<br /> EMPLOYEES<br /> EMPLOYEE_ID NUMBER<br /> DEPARTMENT_ID NUMBER<br /> MANAGER_ID NUMBER<br /> LAST_NAME VARCHAR2(25)<br /> DEPARTMENTS<br /> DEPARTMENT_ID NUMBER<br /> MANAGER_ID NUMBER<br /> DEPARTMENT_NAME VARCHAR2(35)<br /> LOCATION_ID NUMBER<br /> You want to create a report displaying employee last names, department names, and locations. Which query should you use?（）<p> Examine the structure of the EMPLOYEES and DEPARTMENTS tables:<br /> EMPLOYEES<br /> EMPLOYEE_ID NUMBER<br /> DEPARTMENT_ID NUMBER<br /> MANAGER_ID NUMBER<br /> LAST_NAME VARCHAR2(25)<br /> DEPARTMENTS<br /> DEPARTMENT_ID NUMBER<br /> MANAGER_ID NUMBER<br /> DEPARTMENT_NAME VARCHAR2(35)<br /> LOCATION_ID NUMBER<br /> You want to create a report displaying employee last names, department names, and locations. Which query should you use?（）</p>
A、A.SELECT e.last_name, d. department_name, d.location_id FROM employees e NATURAL JOIN departments D USING department_id ;
B、B.SELECT last_name, department_name, location_id FROM employees NATURAL JOIN departments WHERE e.department_id =d.department_id;
C、C.SELECT e.last_name, d.department_name, d.location_id FROM employees e NATURAL JOIN departments d;
D、D.SELECT e.last_name, d.department_name, d.location_id FROM employees e JOIN departments d USING (department_id );
查看正确答案
