USE T202627
GO

UPDATE A
SET
    A.SuppName = B.SuppName,
    A.SuppGrpCode = B.SuppGrpCode,
    A.SuppAdd1 = B.SuppAdd1,
    A.SuppAdd2 = B.SuppAdd2,
    A.SuppAdd3 = B.SuppAdd3,
    A.SuppCityName = B.SuppCityName,
    A.SuppCityPin = B.SuppCityPin,
    A.SuppPhone = B.SuppPhone,
    A.SuppMobile = B.SuppMobile,
    A.SuppFax = B.SuppFax,
    A.SuppEmail = B.SuppEmail,
    A.SuppVATNo = B.SuppVATNo,
    A.SuppCSTNo = B.SuppCSTNo,
    A.SuppGSTNo = B.SuppGSTNo,
    A.SuppPANNo = B.SuppPANNo,
    A.SuppPropMan = B.SuppPropMan,
    A.SuppDueDays = B.SuppDueDays,
    A.SuppDealsIn = B.SuppDealsIn,
    A.SuppMarket = B.SuppMarket,
    A.SuppResPhone = B.SuppResPhone,
    A.SuppDisc = B.SuppDisc,
    A.SuppPcsRD = B.SuppPcsRD,
    A.SuppMtrRD = B.SuppMtrRD,
    A.CommPerc = B.CommPerc,
    A.Dhara = B.Dhara,
    A.Days = B.Days,
    A.PackPerPcs = B.PackPerPcs,
    A.BankComm = B.BankComm,
    A.CourierCharge = B.CourierCharge,
    A.DharaRDPerPcs = B.DharaRDPerPcs,
    A.DharaRDPerMts = B.DharaRDPerMts,
    A.Remark = B.Remark,
    A.BankName = B.BankName,
    A.BankAccNo = B.BankAccNo,
    A.BankBranch = B.BankBranch,
    A.BankIFSCCode = B.BankIFSCCode,
    A.SuppFirmCode = B.SuppFirmCode,
    A.CommissionBy = B.CommissionBy,
    A.SuppSubAgent = B.SuppSubAgent,
    A.BlackListed = B.BlackListed,
    A.UdyamRegNumber = B.UdyamRegNumber,
    A.EnterpriseType = B.EnterpriseType,
    A.EnterpriseActivity = B.EnterpriseActivity,
    A.ReceiverName = B.ReceiverName,
    A.GSTRegDate = B.GSTRegDate
FROM T202627.dbo.SUPPLIER_MASTER A
INNER JOIN T202526.dbo.SUPPLIER_MASTER B
    ON A.SuppCode = B.SuppCode
GO