错误 #2782
(收费管理科)非药品调节功能中,预定几天后调价,但发现价格没有调整
0%
描述
UPDATE fin_com_undruginfo t1
SET t1.unit_price2 = (SELECT t2.unit_price2
FROM fin_com_adjustundrugpricedetai t2
WHERE t1.item_code = t2.item_code and t2.adjustprice_no = '27614')
WHERE EXISTS (SELECT t2.unit_price2
FROM fin_com_adjustundrugpricedetai t2
WHERE t1.item_code = t2.item_code and t2.adjustprice_no = '27614');
UPDATE fin_com_undruginfo t1
SET t1.unit_price1 = (SELECT t2.unit_price1
FROM fin_com_adjustundrugpricedetai t2
WHERE t1.item_code = t2.item_code and t2.adjustprice_no = '27614')
WHERE EXISTS (SELECT t2.unit_price1
FROM fin_com_adjustundrugpricedetai t2
WHERE t1.item_code = t2.item_code and t2.adjustprice_no = '27614');
UPDATE fin_com_undruginfo t1
SET t1.unit_price = (SELECT t2.unit_price
FROM fin_com_adjustundrugpricedetai t2
WHERE t1.item_code = t2.item_code and t2.adjustprice_no = '27614')
WHERE EXISTS (SELECT t2.unit_price
FROM fin_com_adjustundrugpricedetai t2
WHERE t1.item_code = t2.item_code and t2.adjustprice_no = '27614');