select d.zyhghh,a.yzmxid,a.zlxmjc,a.qyrq00,a.kzys00,sum(d.sl0000) sl0000,sum(d.zje000) hjje00 ,d.brxm00 ,   (select zwxm00 from  bm_ygbm00 where ygbh00=a.kzys00) kzysxm ,SF_ZS_RYZDMC_DZBL(a.zyid00,'c',2) ZDMC00  from  bq_yjyz00 a,yj_yw0000 d where a.yzmxid=d.yzcfid and a.zyid00=d.zyghid and  d.sfdjh0<>'0'  and exists (select 1 from xt_zlsfgx b,bm_yysfxm c,bm_zlzd00 e where b.zlxmid=e.zlxmid and b.sfxmid=c.sfxmid and d.zlxmid=e.zlxmid and c.bh0000 like '04%' and c.flag00='1' and c.bh0000 not like '040%' and c.bh0000 not like '048%' )  and a.qyrq00>='20141230' and a.qyrq00<='20141230' and a.ksh000=37 group by a.yzmxid, a.zlxmjc, a.qyrq00, a.kzys00 ,d.zyhghh,a.zyid00,d.brxm00