UPDATE product as p, productPrice as pp SET pp.price = pp.price * 0.8 WHERE p.productId = pp.productId AND p.dateCreated < '2004-01-01' UPDATE updatefrom p, updateto pp SET pp.last_name = p.last_name WHERE pp.visid = p.id