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)

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)