Yurttas/PL/DBL/oracle/F/01/Company-A/q06.sql

From ZCubes Wiki
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);