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