use t20a001

UPDATE HASTE_MASTER SET HasAdd1=T1.HasAdd1, HasAdd2=T1.HasAdd2, HasAdd3=T1.HasAdd3, HasCityName=T1.HasCityName, HasCityPin=T1.HasCityPin, HasPhone=T1.HasPhone, HasMobile=T1.HasMobile, HasFax=T1.HasFax, HasEmail=T1.HasEmail, HasResident=T1.HasResident, HasGSTNo=T1.HasGSTNo, HasCSTNo=T1.HasCSTNo, HasContPerson=T1.HasContPerson, HasKSTNo=T1.HasKSTNo, HasTransport=T1.HasTransport, TINNo=T1.TINNo, InsPolicyNo=T1.InsPolicyNo, PANNo=T1.PANNo, GSTIN=T1.GSTIN, CompScheme=T1.CompScheme, GSTRegDate=T1.GSTRegDate, AccManager=T1.AccManager, CityDistanceKM=T1.CityDistanceKM FROM 
(SELECT Haste AS F0, HasAdd1, HasAdd2, HasAdd3, HasCityName, HasCityPin, HasPhone, HasMobile, HasFax, HasEmail, HasResident, HasGSTNo, HasCSTNo, HasContPerson, HasKSTNo, HasTransport, TINNo, InsPolicyNo, PANNo, GSTIN, CompScheme, GSTRegDate, AccManager, CityDistanceKM 
FROM T19A001.DBO.HASTE_MASTER) AS T1 WHERE T1.F0 collate database_default= Haste