UPDATE SUPPLIER_MASTER SET SuppName = T1.F2 from (SELECT SuppCode AS F1, SuppName AS F2 FROM T202223.DBO.SUPPLIER_MASTER) AS T1 WHERE T1.F1 COLLATE DATABASE_DEFAULT = SuppCode

UPDATE CUSTOMER_MASTER SET CustName = T1.F2 from (SELECT CustCode AS F1, CustName AS F2 FROM T202223.DBO.CUSTOMER_MASTER) AS T1 WHERE T1.F1 COLLATE DATABASE_DEFAULT = CustCode