Removing Duplicates

SELECT DISTINCT Company.name

FROM Company, Product

WHERE Company.name=maker

AND (Product.name,price) IN

(SELECT product, price)

FROM Purchase

WHERE buyer = ‘Joe Blow’);

Previous slide

Next slide

Back to first slide

View graphic version