两张表中某个子段的关联

update examination set patient_id = (select patient_id from match where match.treatment_id=examination.treatment_id) where examination.treatment_id in (select treatment_id from match)