Joins

SELECT name, store

FROM Person, Purchase

WHERE name=buyer

AND city=‘Seattle’

AND product=‘gizmo’

Product ( name, price, category, maker)

Purchase (buyer, seller, store, product)

Company (name, stock price, country)

Person( name, phone number, city)

Previous slide

Next slide

Back to first slide

View graphic version