Joins

SELECT name, store

FROM Person, Purchase

WHERE per-name=buyer AND city=“Seattle”

AND product=“gizmo”

Product ( pname, price, category, maker)

Purchase (buyer, seller, store, product)

Company (cname, stock price, country)

Person( per-name, phone number, city)

Previous slide

Next slide

Back to first slide

View graphic version