update rms_originalinfo a
set a.fault_id = (select hd_fault_id from t_dz_fault_temp b where b.id = a.id)
where a.id in (select id from t_dz_fault_temp)
set a.fault_id = (select hd_fault_id from t_dz_fault_temp b where b.id = a.id)
where a.id in (select id from t_dz_fault_temp)