Consider the following table structure and write a query to display all the employees who have and don’t have department id assigned
Answer options
A
Emp(fname,lname,dno)
B
Dept(dep9d,dname)
C
1) SELECT FNAME,DEPTID,DNAME FROM EMP E LEFT OUTER JOIN DEPT D
Correct answer: 1) SELECT FNAME,DEPTID,DNAME FROM EMP E LEFT OUTER JOIN DEPT D
Explanation
The source marks the correct answer as: 1) SELECT FNAME,DEPTID,DNAME FROM EMP E LEFT OUTER JOIN DEPT D.