29
What Happens When We Query a View ?
• SELECT   name, Seattle-view.store
• FROM      Seattle-view, Product
• WHERE   Seattle-view.product = Product.name  AND
•                  Product.category = “shoes”
SELECT  name, Purchase.store
FROM     Person, Purchase, Product
WHERE  Person.city = “Seattle”    AND
                Person.name = Purchase.buyer   AND
                Purchase.poduct = Product.name  AND
                Product.category = “shoes”