Yurttas/PL/DBL/oracle/F/01/Company-A/q05.sql

 1REM
 2REM q05.sql
 3REM
 4REM Retrieve the names of employees who work on every project.
 5REM
 6
 7SELECT DISTINCT E1.fname, E1.minit, E1.lname
 8FROM Employee E1
 9WHERE NOT EXISTS (SELECT pno
10                  FROM WorksOn
11                  WHERE pno NOT IN (SELECT pno
12                                    FROM Employee E2, WorksOn
13                                    WHERE essn = E2.ssn
14                                      AND E2.ssn = E1.ssn));