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

From ZCubes Wiki
Revision as of 22:54, 4 November 2013 by MassBot1 (talk | contribs) (Created page with "<syntaxhighlight lang="sql" line start="1" enclose="div"> REM REM q09.sql REM REM Find the names and the addresses of employees who work REM on at least one project located in...")
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
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';
Retrieved from "http://wiki.zcubes.com/index.php?title=Yurttas/PL/DBL/oracle/F/01/Company-A/q09.sql&oldid=79116"