Yurttas/PL/DBL/mssql/F/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(SELECT PC.model, price
11 FROM Product P, PC
12 WHERE maker='B'
13   AND P.model=PC.model )
14UNION
15(SELECT L.model, L.price
16 FROM Product P, Laptop L
17 WHERE maker='B'
18   AND P.model=L.model)
19UNION
20(SELECT R.model, R.price
21 FROM Product P, Printer R
22 WHERE P.maker='B'
23   AND P.model=R.model);