UPDATE a SET a.dc_in_id = b.dc_in_id FROM T_MR_sjzb2 a,t_dc_inhospital_info b WHERE a.dc_in_id = b.hospitalization_code AND a.mr_id = to_char(b.out_date,'yyyy-mm-dd')
这个?