69
Conditions on Tuples
SELECT
DISTINCT
Company.name
FROM
Company, Product
WHERE
Company.name= Product.maker
AND
(Product.name,price)
IN
(
SELECT
Purchase.product, Purchase.price)
FROM
Purchase
WHERE
Purchase.buyer = “Joe Blow”);
May not work in SQL server...