Yurttas/PL/DBL/oracle/F/01/Company-B/q061.sql

 1REM
 2REM q061.sql
 3REM
 4REM Find all employees who do not work for 'First Bank Corporation'.
 5REM
 6REM [ Assume that people may work for several companies. ]
 7REM
 8
 9SELECT employeename 
10FROM Employee
11WHERE employeename NOT IN (SELECT employeename 
12                           FROM Works 
13                           WHERE companyname='First Bank Corporation');