oracle update left join查询

记下以防忘记

update (select a.approval_content as acontent from T_EM_SITUATION t left join t_em_situation_approval a on t.situation_id=a.situation_id 
 where a.approval_content = '2452452') p set  p.acontent = '2' ;