使用SQL从INNER JOIN转换UPDATE以在MySQL中使用

使用SQL从INNER JOIN转换UPDATE以在MySQL中使用

UPDATe product SET price = 12.95 WHERe product_id in(SELECT product_id FROM product_to_category INNER JOIN category ON product_to_category.category_id = category.category_id WHERe category.parent_id = 39)