Yurttas/PL/DBL/oracle/F/01/Company-B/q061.sql
Jump to navigation
Jump to search
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');