USE T24W001
DELETE FROM AGENT_MASTER WHERE AGENTNAME='MAHADEV AGENCY' AND AGENTCODE NOT IN (SELECT ACCAGENTCODE FROM ACCOUNT_MASTER)




USE COMMON
USE T24W001

update ACCOUNT_MASTER set TransName='' WHERE TransName='DIAMOND TRANSPORT' 
update ACCOUNT_MASTER set TransName=T1.F1 FROM (SELECT TRANSNAME AS F1, CUSTCODE AS F2 FROM BILL_DETAIL) AS T1 WHERE T1.F2 = ACCCODE