在sql中添加两个带有join和groupby的sum

Question

SELECT t1.id, t1.name,SUM(t3.points), SUM(t2.points)
FROM app_users t1
LEFT JOIN loyalty_points_redeem t3 ON t3.app_user_id = t1.id
LEFT JOIN loyalty_points_gain t2 ON t2.app_user_id = t1.id    
GROUP BY t1.id

我想从表中计算一个粒子的和，第一个和可以，但另一个不正确，我是sql新手，如何解决这个问题，如果有任何想法，请帮助

Answer 1

您可以在下面的子句中添加t1.name

SELECT t1.id, t1.name,SUM(t3.points), SUM(t2.points)
FROM app_users t1
LEFT JOIN loyalty_points_redeem t3 ON t3.app_user_id = t1.id
LEFT JOIN loyalty_points_gain t2 ON t2.app_user_id = t1.id    
GROUP BY t1.id,t1.name

Answer 2

在GROUP BY 中看不到其他问题

SELECT t1.id, t1.name,SUM(t3.points), SUM(t2.points)
FROM app_users t1
LEFT JOIN loyalty_points_redeem t3 ON t3.app_user_id = t1.id
LEFT JOIN loyalty_points_gain t2 ON t2.app_user_id = t1.id    
GROUP BY t1.id, t1.name