select c.bm_bumen,sum(fdpiaoshu),sum(rtpiaoshu) from zh_piaoshu a join zh_bumen b on a.zh_zhanghao=b.zh_zhanghao join bu_bumen c on b.bm_bianhao =c.bm_bianhao where a.qishu=1
select c.bm_bumen,sum(fdpiaoshu),sum(rtpiaoshu) from zh_piaoshu a join zh_bumen b on a.zh_zhanghao=b.zh_zhanghao join bu_bumen c on b.bm_bianhao =c.bm_bianhao where a.qishu=1 group by c.bm_bumen
select bu_bumen.bm_bumen ,sum ( ps_fdpiaoshu ) as dd , sum ( ps_rtpiaoshu ) as uu from zh_piaoshu inner join zh_bumen on zh_piaoshu.zh_zhanghao=zh_bumen.zh_zhanghao inner join bu_bumen on bu_bumen.bm_bianhao =zh_bumen.bm_bianhao where zh_piaoshu.qs_qishu=1 order by dd desc 报错啊 消息 8120,级别 16,状态 1,第 1 行 选择列表中的列 'bu_bumen.bm_bumen' 无效,因为该列没有包含在聚合函数或 GROUP BY 子句中。
on a.zh_zhanghao=b.zh_zhanghao join bu_bumen c on b.bm_bianhao =c.bm_bianhao where a.qishu=1
on a.zh_zhanghao=b.zh_zhanghao join bu_bumen c on b.bm_bianhao =c.bm_bianhao where a.qishu=1
group by c.bm_bumen
on zh_piaoshu.zh_zhanghao=zh_bumen.zh_zhanghao inner join bu_bumen on bu_bumen.bm_bianhao =zh_bumen.bm_bianhao where zh_piaoshu.qs_qishu=1
order by dd desc
报错啊 消息 8120,级别 16,状态 1,第 1 行
选择列表中的列 'bu_bumen.bm_bumen' 无效,因为该列没有包含在聚合函数或 GROUP BY 子句中。