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

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