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

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