我试图总结总喜欢和评论，但结果总是零 (0) 请帮助我解决这个问题，因为我已经实施了我发现但没有成功的大部分解决方案。
SELECT DISTINCT id,name,picture,
(SELECT COUNT(id) from likes) as likes,
(SELECT COUNT(id) from comments) as comments,
(likes+comments) as total
From users
您不能在SELECT定义列别名的地方使用列别名。我建议在FROM条款中这样做：
SELECT DISTINCT u.id, u.name, u.picture, l.likes, c.comments,
(l.likes + c.comments) as total
FROM users u CROSS JOIN
(SELECT COUNT(id) as likes FROM likes) l CROSS JOIN
(SELECT COUNT(id) as comments FROM comments) c;
想必，u.id是独一无二的。如果是这样，您应该删除SELECT DISTINCT. 它只会对性能产生不利影响。
本文收集自互联网，转载请注明来源。
如有侵权，请联系[email protected] 删除。
我来说两句