select sum(a.fyze) as fyze,count(*) as rs,sum(a.tcbz) as bxje,b.kkje,c.yymc from hzyl_bzjl a left join (select yyid,sum(tcbz) as kkje from hzyl_bzjl where bhl=1 group by yyid) b on a.yyid=b.yyid left join hzyl_xyxm c on a.yyid=c.yydm group by c.yymc
,b.kkje
,b.kkje
select 所查询的要么是出现在group by子句中的字段,要么就是通过聚合函数得到的