55
Tuple Variables
General rule:
tuple variables introduced automatically by the system:
tuple variables introduced automatically by the system:
Product (name, price, category, manufacturer)
Becomes:
Doesn’t
work when Product occurs more than once:
In
that case the user needs to define variables explicitly.
SELECT
name
FROM Product
WHERE price > 100
SELECT Product.name
FROM Product AS
Product
WHERE Product.price
> 100