SQL LEFT JOIN SUM()函数怎么用
答案:1 悬赏:0 手机版
解决时间 2021-11-18 12:20
- 提问者网友:藍了天白赴美
- 2021-11-18 02:24
SQL LEFT JOIN SUM()函数怎么用
最佳答案
- 五星知识达人网友:罪歌
- 2021-11-18 02:58
SELECt A.*,B.uid,B.money as heji FROM A
LEFT JOIN (SELECt uid,sum(money) FROM A) b ON A.uid=B.uid解析
SELECt uid,sum(money) FROM Asum()为集合函数 查询多个列时需要使用GROUP BY
正确语法
SELECt uid,sum(money) FROM A GROUP BY uid第二条SQL语句
SELECt go_member.*,go_member_account.uid,go_member_account.money as heji
FROM `go_member` LEFT JOIN
(SELECt uid,sum(money) FROM go_member_account ) b
ON go_member.uid=go_member_account.uid解析
ON go_member.uid=go_member_account.uid条件错误
LEFT JOIN
(SELECt uid,sum(money) FROM go_member_account ) b子查询 相当于把表go_member_account
复制给B了 这个表go_member_account不存在
ON go_member.uid=b.uid追问
go_member_account表为用户消费记录表,go_member为用户注册表,我想查询每位用户消费总金额,麻烦了
追答SELECt * FROM go_member A LEFT JOIN
(SELECt 用户ID,sum(消费金额) FROM go_member_account GROUP BY 用户ID) B
ON A.用户ID=B.用户ID上面没有消费记录的消费金额为0
SELECt A.用户ID,SUM(消费金额) FROM go_member_account A,go_member B
WHERe A.用户ID=B.用户ID
GROUP BY A.用户ID上面没有消费的不会显示
LEFT JOIN (SELECt uid,sum(money) FROM A) b ON A.uid=B.uid解析
SELECt uid,sum(money) FROM Asum()为集合函数 查询多个列时需要使用GROUP BY
正确语法
SELECt uid,sum(money) FROM A GROUP BY uid第二条SQL语句
SELECt go_member.*,go_member_account.uid,go_member_account.money as heji
FROM `go_member` LEFT JOIN
(SELECt uid,sum(money) FROM go_member_account ) b
ON go_member.uid=go_member_account.uid解析
ON go_member.uid=go_member_account.uid条件错误
LEFT JOIN
(SELECt uid,sum(money) FROM go_member_account ) b子查询 相当于把表go_member_account
复制给B了 这个表go_member_account不存在
ON go_member.uid=b.uid追问
go_member_account表为用户消费记录表,go_member为用户注册表,我想查询每位用户消费总金额,麻烦了
追答SELECt * FROM go_member A LEFT JOIN
(SELECt 用户ID,sum(消费金额) FROM go_member_account GROUP BY 用户ID) B
ON A.用户ID=B.用户ID上面没有消费记录的消费金额为0
SELECt A.用户ID,SUM(消费金额) FROM go_member_account A,go_member B
WHERe A.用户ID=B.用户ID
GROUP BY A.用户ID上面没有消费的不会显示
我要举报
如以上问答信息为低俗、色情、不良、暴力、侵权、涉及违法等信息,可以点下面链接进行举报!
大家都在看
推荐资讯