USE T23V001

update ACCOUNT_MASTER set TransName='' WHERE TransName='MERGE' 

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