What does the following query return? SELECT E.EMP_ID, E.EMP_NAME, D.DEPT_NAME
FROM Employees E FULL OUTER JOIN Departments D
ON E.DEPT_ID = D.DEPT_ID;

Question

What does the following query return? SELECT  E.EMP_ID, E.EMP_NAME, D.DEPT_NAME  
 FROM  Employees E  FULL OUTER JOIN  Departments D  
 ON  E.DEPT_ID = D.DEPT_ID;

Accepted Answer

All employees and departments (including nulls)

Answer

All employees and departments (excluding nulls)

Answer

Only matching employees and departments

Answer

Employees without departments

Crowdly

What does the following query return? SELECT E.EMP_ID, E.EMP_NAME, D.DEPT_NAME ...

Want instant access to all verified answers on eclass.yorku.ca?