USE T22R003

UPDATE T23R003.DBO.ACCOUNT_MASTER SET ACCType = t1.f2 from (SELECT ACCCODE AS F1, ACCTYPE AS F2 FROM T22R003.DBO.ACCOUNT_MASTER) AS T1 WHERE T1.F1 COLLATE DATABASE_DEFAULT= ACCCODE