USE T202627
GO

UPDATE A
SET
    A.CustName = B.CustName,
    A.CustGrpCode = B.CustGrpCode,
    A.CustSubAgentCode = B.CustSubAgentCode,
    A.CustAdd1 = B.CustAdd1,
    A.CustAdd2 = B.CustAdd2,
    A.CustAdd3 = B.CustAdd3,
    A.CustCityName = B.CustCityName,
    A.CustCityPin = B.CustCityPin,
    A.CustPhone = B.CustPhone,
    A.CustMobile = B.CustMobile,
    A.CustFax = B.CustFax,
    A.CustEmail = B.CustEmail,
    A.CustVATNo = B.CustVATNo,
    A.CustCSTNo = B.CustCSTNo,
    A.CustGSTNo = B.CustGSTNo,
    A.CustPANNo = B.CustPANNo,
    A.CustPropMan = B.CustPropMan,
    A.CustRef = B.CustRef,
    A.CustCrDays = B.CustCrDays,
    A.CustCrLimit = B.CustCrLimit,
    A.CustBilltyForwarding = B.CustBilltyForwarding,
    A.CustDealsIn = B.CustDealsIn,
    A.CustResPhone = B.CustResPhone,
    A.CustFirmCode = B.CustFirmCode,
    A.District = B.District,
    A.CourierName = B.CourierName,
    A.BrokLessInPayment = B.BrokLessInPayment,
    A.BlackListed = B.BlackListed,
    A.UdyamRegNumber = B.UdyamRegNumber,
    A.EnterpriseType = B.EnterpriseType,
    A.EnterpriseActivity = B.EnterpriseActivity,
    A.BankName = B.BankName,
    A.BankAccNo = B.BankAccNo,
    A.BankBranch = B.BankBranch,
    A.BankIFSCCode = B.BankIFSCCode
FROM T202627.dbo.CUSTOMER_MASTER A
INNER JOIN T202526.dbo.CUSTOMER_MASTER B
    ON A.CustCode = B.CustCode
GO