统计诊断符合路径诊断但是未入径（点排除入径）填写勾选或填写的排除描述相关信息
SELECT c.bmmc00 as 科室,
(select e.ljmc00 from lj_mb0000 e where e.ljid00=A.ljid00) as 路径名称,
b.zyh000 as 住院号,b.xm0000 as 病人姓名,b.sxysxm as 住院医生,
b.zzysxm as 主治医生,b.zrysxm as 主任医生,b.sjryrq as 入院日期,
(select d.zdmc00 from bq_brzdxx d where  d.zyid00=b.zyid00 and zdlb00='2' and rownum='1') as 西医入院诊断,
(select d.zdmc00 from bq_brzdxx d where  d.zyid00=b.zyid00 and zdlb00='c' and rownum='1') as 中医入院诊断,
A.NR0000 as 排除原因,A.CZRQ00 as 排除日期 FROM  LJ_BRRJZZ A,ZY_BRXXB0 B,bm_bmbm00 c WHERE A.ZYID00=B.ZYID00 and c.bmbh00=b.dqks00 
AND B.SJCYRQ BETWEEN  '20160801' AND '20160831' and c.yyid00='A' 
AND A.NR0000 is  not null order by c.bmmc00