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');