UPDATE   PRODUCT

SET    price = price/2

WHERE  Product.name  IN

                    (SELECT product

                      FROM    Purchase

                      WHERE  Date =‘Oct, 25, 1999’);