Yurttas/PL/DBL/mysql-f-2010/01/PC/q03.sql

 1/*
 2REM
 3REM q03.sql
 4REM
 5REM Find the model number and price of all products
 6REM (of any type) made by manufacturer 'B'.
 7REM
 8*/
 9
10\. set-db.sql
11
12(SELECT PC.model, price
13 FROM Product P, PC
14 WHERE maker='B'
15   AND P.model=PC.model )
16UNION
17(SELECT L.model, L.price
18 FROM Product P, Laptop L
19 WHERE maker='B'
20   AND P.model=L.model)
21UNION
22(SELECT R.model, R.price
23 FROM Product P, Printer R
24 WHERE P.maker='B'
25   AND P.model=R.model);