临时视图

with T_FORM as (select F.FORM_ID_, F.FORM_STATUS_ from OA_FORM F)
  select T_FORM.FORM_ID_ from T_FORM inner join OA_APPROVAL_MEMO AM on AM.FORM_ID_ = T_FORM.FORM_ID_