select ghyxm0,ghlb00,ghlbmc,sum(ghcs00),sum(ghje00),sum(zcje00),sum(ghf000) from VW_SF_GHLSXX where ghy000 in(select xkh000 from vw_ys_fpys00) and jzrq00 between :开始日期 and :结束日期 and ghlb00<>'-99999' group by ghyxm0,ghlb00,ghlbmc order by ghyxm0,ghlb00