//test1
//test2
test1.age --- 1:n -- test2.age
SELECT
sum(t1.money),
t1.age
FROM
test1 t1
LEFT JOIN test2 t2 ON t2.age = t1.age
GROUP BY
t1.age;
//结果是 错误的 如下
加上count就很明显了
SELECT
count(t1.id),
sum(t1.money),
t1.age
FROM
test1 t1
LEFT JOIN test2 t2 ON t2.age = t1.age
GROUP BY
t1.age;
t1.money 计算了三次
解决方法