UPDATE SEND_TO_JOB SET DispFromAdd1='',DispFromAdd2='',DispFromCityName=T1.F1, DispFromCityPIN=T1.F2 FROM (SELECT ACCOUNT_MASTER.AccCityName AS F1, ACCOUNT_MASTER.AccCityPin AS F2, SEND_TO_JOB.SrNo AS F3 FROM SEND_TO_JOB INNER JOIN ACCOUNT_MASTER ON ACCOUNT_MASTER.AccCode = SEND_TO_JOB.JobCode) AS T1 WHERE T1.F3 COLLATE DATABASE_DEFAULT = JobCode
        
UPDATE SEND_TO_JOB SET DispToAdd1='',DispToAdd2='',DispToCityName=(SELECT CompCityName FROM COMPANY_DETAIL), DispToCityPIN=(SELECT CompCityPin FROM COMPANY_DETAIL)