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

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