有病理收费项目但是首页无病理诊断：

select a.zyh000 as 住院号,a.xm0000 as 姓名,e.bmmc00 as 住院科室,a.zzysxm as 主管医生,a.ryzdmc as 入院诊断,
 (select zdmc00 from bq_brzdxx w where zdlb00 = '3' and rownum <= 1 and w.zyid00 = a.zyid00) as 西医出院主要诊断,
 d.xmmc00 as 收费项目名称,a.sjcyrq as 出院日期
from zy_brxxb0 a,zy_brfy00 b,zy_fymx00 c,bm_yysfxm d,bm_bmbm00 e where b.djh000=c.djh000 
and c.xmbh00=d.sfxmid and 
b.zyid00=a.zyid00 and a.dqks00=e.bmbh00 and d.bh0000||'' like '027%' and a.sjcyrq between '20150416' and '20150528'
and exists (select 1 from ba_brzyxx h where trim(h.BLZD00) is null and h.lsh000=a.zyid00) order by a.zyh000





8月份病理收费项目人数

select count(distinct(a.zyid00)) as zyid00 
from zy_brxxb0 a,zy_brfy00 b,zy_fymx00 c,bm_yysfxm d,bm_bmbm00 e where b.djh000=c.djh000 
and c.xmbh00=d.sfxmid and 
b.zyid00=a.zyid00 and a.dqks00=e.bmbh00 and d.bh0000||'' like '027%' and a.sjcyrq between '20150801' and '20150831'
order by a.zyid00