USE T25M001


UPDATE CHALLAN_DETAIL SET AgentCode = T1.F2 FROM (SELECT AccCode AS F1, AccAgentCode AS F2 FROM ACCOUNT_MASTER) AS T1 WHERE T1.F1 = CustCode
UPDATE BILL_DETAIL SET AgentCode = T1.F2 FROM (SELECT AccCode AS F1, AccAgentCode AS F2 FROM ACCOUNT_MASTER) AS T1 WHERE T1.F1 = CustCode
UPDATE FINISHED_PURCHASE SET WeaverAgentCode = T1.F2 FROM (SELECT AccCode AS F1, AccAgentCode AS F2 FROM ACCOUNT_MASTER) AS T1 WHERE T1.F1 = WeaverCode
UPDATE GREY_PURCHASE SET WeaverAgentCode = T1.F2 FROM (SELECT AccCode AS F1, AccAgentCode AS F2 FROM ACCOUNT_MASTER) AS T1 WHERE T1.F1 = WeaverCode
UPDATE RECEIVED_FROM_JOB SET AgentCode = T1.F2 FROM (SELECT AccCode AS F1, AccAgentCode AS F2 FROM ACCOUNT_MASTER) AS T1 WHERE T1.F1 = JobCode