Yurttas/PL/DBL/oracle/F/01/Company-A/q06.sql
Jump to navigation
Jump to search
1REM
2REM q06.sql
3REM
4REM Retrieve the names of employees who do not work
5REM on any project.
6REM
7
8SELECT fname, minit, lname
9FROM Employee
10WHERE ssn NOT IN (SELECT essn
11 FROM WorksOn
12 WHERE essn = ssn);