select * from 病案主页 where 病人id in (select 病人id from 病人医嘱记录 where 开嘱时间 between sysdate-10 and sysdate and 医嘱内容 ='住院')
and 入院日期  between sysdate-10 and sysdate 


查询门诊开住院记录



select rownum,a.* from (select decode(b.参保类别,1,'职工',2,'居民','自费') as 参保类别,
       a.姓名,
       a.性别,
       a.年龄,
       a.住院号,
       a.入院日期,
       a.出院日期,
       a.门诊医师,
       a.责任护士,
       a.住院医师,
       a.出院病床,
       a.医疗付款方式,
       d.结帐金额,c.名称 as 出院科室
  from 病案主页 a, 就诊登记记录 b, 部门表 c,病人结帐记录 d
 where a.出院科室id = c.id
   and a.病人id = b.病人id(+)
   and a.主页id = b.主页id(+)
   and a.病人id = d.病人id
   and a.主页id = d.主页id
   and a.出院日期 between /*B0*/TO_DATE('2022-03-02 00:00:00','YYYY-MM-DD HH24:MI:SS')/*E0*/ and /*B1*/TO_DATE('2022-03-28 23:59:59','YYYY-MM-DD HH24:MI:SS')/*E1*/
  -- and a.出院科室id  /*B2*/ IN (79) /*E2*/
   and nvl(a.病人类型,'普通病人') /*B3*/is not null/*E3*/
   order by a.出院日期
) a

自费出院病人信息