UPDATE T1
SET T1.VHCL_MDL_CD = T2.VHCL_MDL_CD
FROM DBS_SRC.dbo.RDR_SRC_Preprocess T1,DBS_SRC.dbo.VHCL_4RDR T2 WHERE T1.VIN_ID=T2.VIN_ID;
SET T1.VHCL_MDL_CD = T2.VHCL_MDL_CD
FROM DBS_SRC.dbo.RDR_SRC_Preprocess T1,DBS_SRC.dbo.VHCL_4RDR T2 WHERE T1.VIN_ID=T2.VIN_ID;