SQL查询同一张表同一字段不同条件的和,就像图上的,统计出优惠金额总和和总金额总和 我的语句是这样的 select a.name,SUM(a.money),SUM(b.money) from consum a left join (select * from consum b where flag =1) b on a.name=b.name group by a.name 就是不对,求原因及正解
Select a.name,a.sum1,b.sum2 (select a.name,sum(a.money) sum1 from consum a group by a.name) a Left join (select a.name,sum(a.money) sum2 from consum a where flag = 1 group by a.name) b On a.name =b.name