Introduction to Database Systems

Joins

Product (pname, price, category, manufacturer)

Purchase (buyer, seller, store, product)

Person(persname, phoneNumber, city)

Find names of people living in Seattle that bought some product in the ‘Gadgets’ category, and the names of the stores they bought such product from

SELECT   DISTINCT persname, store
FROM      Person, Purchase, Product
WHERE   persname=buyer AND product = pname AND
                 city=‘Seattle’ AND category=‘Gadgets’