UPDATE GREY_SEND_TO_MILL_TAKA_DETAIL SET ITEMNAME = T1.F1 FROM (SELECT ItemName AS F1, SrNo AS F2 FROM GREY_PURCHASE_ITEM_DETAIL) AS T1 WHERE T1.F2 = PURSRNO
UPDATE GREY_SEND_TO_MILL  SET ItemName  = T1.F1 FROM (SELECT ItemName as f1, srno as f2 FROM GREY_SEND_TO_MILL_TAKA_DETAIL) as t1 where t1.f2 = srno