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

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