SELECT '上期在院费用合计' xmmc00, decode(sign(to_number(tjrq00)-20090402),1,NVL (SUM (hjje00), 0)-2.7,NVL (SUM (hjje00), 0)) xmje00  
 FROM zy_wjsfy0  WHERE tjrq00 = TO_CHAR (TO_DATE ('20180806', 'yyyymmdd') - 1, 'yyyymmdd')    AND kdbq00 = -1    AND xmlb00 = '0'
 group by tjrq00 UNION ALL SELECT '本期新增住院费用合计' xmmc00, NVL (SUM (hjje00), 0) xmje00   FROM zy_brfy00  
 
 WHERE czrq00 BETWEEN '20180806' AND '20180806' UNION ALL SELECT '本期结算住院费用合计' xmmc00, NVL (SUM (hjje00), 0) xmje00  
 FROM zy_jzb000  
 WHERE jzrq00 BETWEEN '20180806' AND '20180806' UNION ALL SELECT '本期在院费用合计' xmmc00, decode(sign(to_number(tjrq00)-20090402),1,NVL (SUM (hjje00), 0)-2.7,
 NVL (SUM (hjje00), 0)) xmje00   FROM zy_wjsfy0  WHERE tjrq00 = '20180806' AND kdbq00 = -1 AND xmlb00 = '0' group by tjrq00 UNION ALL SELECT   zbmc00, SUM (zbsj00) 
 FROM bq_tjsj00    WHERE zbxz00 = 17      AND tjrq00 BETWEEN '20180806' AND '20180806'      AND bmbh00 = 0      AND zbbh00 = '3' GROUP BY zbmc00 UNION ALL SELECT 
 zbmc00, SUM (zbsj00)     FROM bq_tjsj00    WHERE zbxz00 = 17      AND tjrq00 BETWEEN '20180806' AND '20180806'      AND bmbh00 = 0      AND zbbh00 = '4'
 GROUP BY zbmc00 UNION ALL SELECT   zbmc00, SUM (zbsj00)     FROM bq_tjsj00    WHERE zbxz00 = 17      AND tjrq00 BETWEEN '20180806' AND '20180806'   
 AND bmbh00 = 0      AND zbbh00 = '5' GROUP BY zbmc00 UNION ALL SELECT   zbmc00, SUM (zbsj00)     FROM bq_tjsj00    WHERE zbxz00 = 17    
 AND tjrq00 BETWEEN '20180806' AND '20180806'      AND bmbh00 = 0      AND zbbh00 = '6' GROUP BY zbmc00 UNION ALL SELECT   zbmc00, SUM (zbsj00)   
  FROM bq_tjsj00    WHERE zbxz00 = 17 AND tjrq00 = '20180806' AND bmbh00 = 0 AND zbbh00 = '8' GROUP BY zbmc00