USE T24P001

UPDATE FINISHED_RECEIVED_FROM_MILL_CHALLAN_DETAIL Set MillSendSrNo=T1.F2 FROM (SELECT millChallanNo as f1,SrNo as f2 FROM OPENING_GREY_SEND_TO_MILL) as t1 where MillChallanNo=T1.F1