Difference between revisions of "Yurttas/PL/DBL/mysql/F/01/00/Company-A/q09.sql"
Jump to navigation
Jump to search
(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 ...") |
(No difference)
|
Latest revision as of 16:16, 3 November 2013
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
11\. set-db.sql
12
13SELECT DISTINCT fname, lname, address, dno
14FROM Employee, WorksOn, Project, DeptLocation
15WHERE ssn = essn
16 AND pno = pnumber
17 AND plocation = 'Houston'
18 AND dno = dnumber
19 AND dlocation <> 'Houston';