SELECT   bmmc00, SUM (ghcs00) ghcs00, SUM (hjje00) hjje00
    FROM (SELECT   c.bmmc00, COUNT (DISTINCT b.ghid00) ghcs00,
                   SUM (a.hjje00) hjje00
              FROM sf_jzb000 a, sf_brxxb0 b, bm_bmbm00 c
             WHERE a.mzid00 = b.ghid00
               AND b.ghks00 = c.bmbh00
               AND a.jzrq00 BETWEEN '20130322' AND '20130322'
               AND a.fbbh00 = 3
               AND (a.yblb00, a.fbbh00) IN (SELECT yblb00, fbbh00
                                              FROM ic_ybbrlb
                                             WHERE ybzxlb LIKE '%')
          GROUP BY c.bh0000, c.bmmc00
          UNION ALL
          SELECT   c.bmmc00, COUNT (DISTINCT b.ghid00), SUM (a.hjje00) hjje00
              FROM sf_brfy00 a, sf_brxxb0 b, bm_bmbm00 c
             WHERE a.mzid00 = b.ghid00
               AND b.ghks00 = c.bmbh00
               AND b.ghrq00 BETWEEN '20130322' AND '20130322'
               AND b.fbbh00 <> 3
               AND b.fbbh00 IN (SELECT fbbh00
                                  FROM ic_ybbrlb
                                 WHERE ybzxlb LIKE '%')
          GROUP BY c.bh0000, c.bmmc00)
GROUP BY bmmc00