Yurttas/PL/DBL/mysql-f-2010/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
11\. set-db.sql
12
13SELECT employeename
14FROM Employee
15WHERE employeename NOT IN (SELECT employeename
16                           FROM Works
17                           WHERE companyname='First Bank Corporation');