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

 1REM
 2REM q09.sql
 3REM
 4REM Find the names and the addresses of employees who work
 5REM on at least one project located in 'Houston' but whose
 6REM department has no location in 'Houston'.
 7REM
 8
 9SELECT DISTINCT fname, lname, address, dno
10FROM Employee, WorksOn, Project, DeptLocation
11WHERE ssn = essn
12  AND pno = pnumber
13  AND plocation = 'Houston'
14  AND dno = dnumber
15  AND dlocation <> 'Houston';