Difference between revisions of "Yurttas/PL/DBL/mssql/F/01/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 04:29, 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
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';