set t1.CFPRiceincrease=(select t2.CFPriceincrease from T_IM_StockTransferBillEntry t2 where t2.fid = t1.fsourceBillEntryID )
以上sql 報錯
update T_IM_MoveIssueBillEntry t1set CFPriceincrease=(select t2.CFPriceincrease from T_IM_StockTransferBillEntry t2 where t2.fid = t1.FSourceBillEntryID )
區別就是 t1.CFPriceincrease 與 CFPriceincrease
新聞熱點
疑難解答