The database scheme consists of four tables:
Product(maker, model, type)
PC(code, model, speed, ram, hd, cd, price)
Laptop(code, model, speed, ram, hd, screen, price)
Printer(code, model, color, type, price)
i am practicing how to write select queries and i am having trouble with this question. What the question is asking for is a query which will select product.makers of pc's and not laptops. below shows the table product along with what the correct result should look like.
http://i262.photobucket.com/albums/ii82/markngaby2/block.jpg
Product(maker, model, type)
PC(code, model, speed, ram, hd, cd, price)
Laptop(code, model, speed, ram, hd, screen, price)
Printer(code, model, color, type, price)
i am practicing how to write select queries and i am having trouble with this question. What the question is asking for is a query which will select product.makers of pc's and not laptops. below shows the table product along with what the correct result should look like.
http://i262.photobucket.com/albums/ii82/markngaby2/block.jpg