update CHN_DECORATION_DETAIL a set a.unit_price=(select b.price from CHN_DECORATION_PRODUCT b where a.product_id=b.product_id)
where a.product_id= (select b.product_id from CHN_DECORATION_PRODUCT b where a.product_id=b.product_id)
where a.product_id= (select b.product_id from CHN_DECORATION_PRODUCT b where a.product_id=b.product_id)