mysql - 在sql中使用join和group by添加两个和

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

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

Answer 1

您可以通过在 group by 子句中添加 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