A Different View

CREATE VIEW Seattle-view AS

SELECT buyer, seller, product, store

FROM Person, Purchase

WHERE Person.city = “Seattle” AND

Person.name = Purchase.buyer

We can later use the views:

SELECT name, store

FROM Seattle-view, Product

WHERE Seattle-view.product = Product.name AND

Product.category = “shoes”

What’s really happening when we query a view??