子表
子表
SELECT t1.uname,SUM(t2.score),SUM(t3.prices)FROM test1 t1
LEFT JOIN test2 t2 ON t2.test1_id=t1.id
LEFT JOIN test3 t3 ON t3.test1_id=t1.id
GROUP BY t1.uname
结果
子表
SELECT t1.uname,SUM(t2.score),SUM(t3.prices)FROM test1 t1
LEFT JOIN test2 t2 ON t2.test1_id=t1.id
LEFT JOIN test3 t3 ON t3.test1_id=t1.id
GROUP BY t1.uname
结果