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??

Previous slide

Next slide

Back to first slide

View graphic version