Exercise #2

Console

Execute

SELECT DISTINCT maker
FROM Product 
WHERE model IN (SELECT model
FROM Printer
 )

SELECT DISTINCT maker FROM Product WHERE model IN (SELECT model FROM Printer )

    Scheme

Thus for each row of Product table it is checked whether there is such a model in Printer table. The relationship between these two tables (one-to-many) does presuppose availability of the model in Product table which would be absent in Printer table. As a result we can skip the producer of the printers if his models are not available (in Printer table). As we have already pointed out when discussing schema of data, the product type in Product table, is set as type attribute, which is not taken into account in this case.

If it is still not clear to you how to solve the problem pls. have a look at Chapter 4 «Tips and solutions».

To solve the problem on SQL-EX.RU