UPDATE SELECT

UPDATE `s_product` AS pp, `s_price` AS p
SET pp.udate = p.udate,pp.pdate = p.udate
WHERE pp.idPrice = p.ID
UPDATE `s_product` p,`op_product` pp
SET pp.udate = pp.udate,pp.pdate = p.pdate
WHERE p.idPrice=87 and p.ID=pp.idProd and p.hash=pp.hash
UPDATE `s_product` p
JOIN `op_product` pp on  p.hash=pp.hash
JOIN `o_offer` of on of.ID=pp.idOffer
JOIN `s_route` r on r.ID=of.idRoute
SET pp.udate = pp.udate,pp.pdate = p.pdate
WHERE p.idPrice=87 and r.idCity=1