Which of the following statements can be used to outer-join a table to itself?

Which of the following statements can be used to outer-join a table to itself?

Which of the following statements can be used to outer-join a table to itself?

A.
SELECT E1.EMPLOYEE_ID, E1.MANAGER_ID, E2.EMPLOYEE_ID
FROM EMPLOYEES E1, EMPLOYEES E2
WHERE E1.MANAGER_ID(+) = E2.EMPLOYEE_ID;

B.
SELECT EMPLOYEE_ID, MANAGER_ID
FROM EMPLOYEES
WHERE MANAGER_ID = (+) EMPLOYEES.EMPLOYEE_ID;

C.
SELECT EMPLOYEE_ID, MANAGER_ID
FROM EMPLOYEES (+)
WHERE EMPLOYEES.MANAGER_ID = EMPLOYEES.EMPLOYEE_ID;

D.
SELECT EMPLOYEE_ID, MANAGER_ID
FROM EMPLOYEES
WHERE EMPLOYEES.MANAGER_ID(+) = EMPLOYEES.EMPLOYEE_ID;



Leave a Reply 0

Your email address will not be published. Required fields are marked *