Yurttas/PL/DBL/postgres/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 current_schema();
12SET search_path to "companyb";
13
14SELECT employeename 
15FROM Employee
16WHERE employeename NOT IN (SELECT employeename 
17                           FROM Works 
18                           WHERE companyname='First Bank Corporation');