select id,name,sum(memos) from A where .... group by id,name
select a.* , t.summoney from a inner join (select a.id as id, sum(b.money) as summoney from a inner join b on a.id = b.id where ..... ---是这里要加条件吗?把....替换成你的条件就可以了. group by a.id,b.id) as t on a.id = t.id
我自己改成这样: select a.* , t.summoney from a inner join (select a.id as id, sum(b.money) as summoney,b.adname from a inner join b on a.id = b.id group by a.id,b.adname) as t on a.id = t.id然后这样子就变成了不汇总了
from
a inner join
(select a.id as id, sum(b.money) as summoney from a inner join b on a.id = b.id
where ..... ---是这里要加条件吗?把....替换成你的条件就可以了.
group by a.id,b.id) as t
on a.id = t.id
select a.* , t.summoney
from
a inner join
(select a.id as id, sum(b.money) as summoney,b.adname from a inner join b on a.id = b.id group by a.id,b.adname) as t
on a.id = t.id然后这样子就变成了不汇总了
像您说的那里加条件后,得到的记录也是不汇总的了。