Yurttas/PL/DBL/mssql/F/01/SPJ/q14.sql

 1/*
 2REM
 3REM q14.sql
 4REM
 5REM Construct a table containing a list of project numbers
 6REM for projects that are either located in 'London' or are
 7REM supplied by a 'London' supplier.
 8REM
 9*/
10
11CREATE TABLE LondonProjs (JN VARCHAR(4));
12    
13INSERT INTO LondonProjs
14(SELECT T.JN
15 FROM Shipments T, Suppliers S
16 WHERE T.SN = S.SN
17   AND S.CITY = 'London')
18UNION
19(SELECT JN
20 FROM Projects
21 WHERE CITY = 'London');