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