Exercise: 7

Get the models and prices for all commercially available products (of any type) produced by maker B.

Solution

SELECT PC.model, price
FROM PC
	JOIN Product ON PC.model = Product.model
WHERE maker = 'B'
UNION
SELECT Laptop.model, price
FROM Laptop
	JOIN Product ON Laptop.model = Product.model
WHERE maker = 'B'
UNION
SELECT Printer.model, price
FROM Printer
	JOIN Product ON Printer.model = Product.model
WHERE maker = 'B'