UPDATE work_T_Delivery_Bill as b, T_Delivery_Bill as a
(SET b.Bill_ID=a.Bill_ID, b.BillNumber=a.BillNumber, b.BillDate=a.BillDate, b.InputDate=a.InputDate,
b.InputOperator=a.InputOperator, b.CorrectDate=a.CorrectDate,
b.CorrectOperator=a.CorrectOperator, b.SubDivision_ID=a.SubDivision_ID,
b.Brigade=a.Brigade, b.Sector=a.Sector )
WHERE b.Bill_ID=a.Bill_ID and a.IsNew=2
|