Blessed Tabvirwa: Example: mysql update with inner join

Example: mysql update with inner join UPDATE product INNER JOIN product_price ON product.productId = product_price.productId SET product_price.price = product_price.price * 1.5 WHERE product.dateCreated '2009-10-23' NOTE: This applies to MySQL at ...

blestab.blogspot.com