--新农合病人目录外药品和非药品金额

SELECT b.bmmc00, a.*
  FROM (SELECT   dqks00, SUM (b.hjje00) ylzje0 , --医疗金额 
                 SUM (DECODE (sfyp00, 'Y', b.hjje00, 0)) ypje00 ,--药品金额 
                 SUM (DECODE (sfyp00, 'N', b.hjje00, 0)) fypje00 ,--非药品金额 
                 SUM (DECODE (sfyp00, 'Y', DECODE (b.zfbl00, 1, b.hjje00, 0),0)) zfypje ,--自费药品金额 
                 SUM (DECODE (sfyp00, 'N', DECODE (b.zfbl00, 1, b.hjje00, 0),0)) zffypje  --自费非药品金额 
            FROM vw_zy_zyfymx_t b
           WHERE cyrq00 BETWEEN :开始日期 AND :结束日期
        GROUP BY dqks00) a,
       bm_bmbm00 b
 WHERE a.dqks00 = b.bmbh00