Another Example

• I still have only the result of SeattleView:

SELECT buyer, seller, product, store

FROM Person, Purchase

WHERE Person.city = ‘Seattle’ AND

Person.per-name = Purchase.buyer

• but I want to answer the query

SELECT buyer, seller

FROM Person, Purchase

WHERE Person.city = ‘Seattle’ AND

Person.per-name = Purchase.buyer AND

Person.Phone LIKE ‘206 543 %’.

Previous slide

Next slide

Back to first slide

View graphic version