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