select sum(tcjjzf)-sum(gwybz0) 门诊统筹支出,
       sum(grzhzf)             门诊账户支出,
       sum(ybyl11)             门诊健康账户,
       sum(YBXJZF)+sum(SYBXZF) 门诊现金支出,
       sum(GWYBZ0)             门诊公务员补助,
       sum(hjje00)             门诊支出小计,
       sum(SYBXZF)             商保支付, 
       sum(YLZFJE)             乙类自付, 
       sum(FYBJE0)             非医保费用, 
       sum(ybyl13)             共济账户支出       
 from   sf_jzb000
 WHERE jzrq00 BETWEEN '20130101' AND '20130131'
   AND ybdjh0 <> '0'
   AND yblb00 <> '0'  




SELECT ybdjh0             医保单据号,
       b.brblh0           病历号, 
       ybjzrq||ybjzsj　 医保结算时间,
       b.brxm00           病人姓名,
       hjje00             本次费用,
       tcjjzf             基金支付,
       gwybz0             公务员补助,
       grzhzf             账户支付,
        ybyl11            健康账户支付,
         YBXJZF           个人支付,
          SYBXZF          商保支付,
          YLZFJE             乙类自付,
          FYBJE0             非医保费用,
          ybyl13             共济账户支出 
  FROM sf_jzb000 a, bm_brxxb0 b
 WHERE a.brid00 = b.brid00
   AND jzrq00 BETWEEN '20130101' AND '20130131'
   AND ybdjh0 <> '0'
   AND a.yblb00 <> '0' order by ybjzrq||ybjzsj