Joins

SELECT name, store

FROM Person, Purchase

WHERE name=buyer AND city=‘Seattle’

AND product=‘gizmo’

Purchase (buyer, seller, store, product)

Person( name, phone number, city)

Previous slide

Next slide

Back to first slide

View graphic version