两表更新的SQL写法

两表更新的SQL写法

update his_pat_pres_record a
set a.execute_frequency =(select b.freq_code from code_frequency b where a.execute_frequency=b.freq_name)
where a.execute_frequency in( select freq_name from code_frequency);
commit;