基本连接有问题

发布于 2024-09-14 12:52:12 字数 522 浏览 10 评论 0原文

我有一个名为 tblSport 的表，其中包含 pkSportID 和 fldName 列。
我有一个名为 tblRespondentSport 的表，其中包含列 fkRespondentID 和 fkSportID。

我想返回运动 ID、运动名称和受访者人数。

这是我的查询：

SELECT s.pkSportID AS id, s.fldSport AS sport, r.COUNT(*) AS count FROM tblSport AS s LEFT JOIN tblRespondentSport AS r ON s.pkSportID = r.fkSportID

我收到 MySQL 1064 错误，它显示它位于 COUNT() 中的 * 附近。我是新加入的，所以我确信这是一件微不足道的事情。提前致谢。

原文

I have a table called tblSport which contains the columns pkSportID and fldName.
I have a table called tblRespondentSport which contains the columns fkRespondentID and fkSportID.

I want to return the sport ID, the name of the sport, and the number of respondents.

Here's my query:

SELECT s.pkSportID AS id, s.fldSport AS sport, r.COUNT(*) AS count FROM tblSport AS s LEFT JOIN tblRespondentSport AS r ON s.pkSportID = r.fkSportID

I'm getting a MySQL 1064 error and it says its near the * in COUNT(). I'm new to joins so I'm sure its something trivial. Thanks in advance.

分享到QQ

分享到微博

如果你对这篇内容有疑问，欢迎到本站社区发帖提问参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。

发布评论

需要登录才能够评论，你可以免费注册一个本站的账号。

不必在意 2024-09-21 12:52:12

您缺少 Group BY

SELECT s.pkSportID AS id, s.fldSport AS sport, COUNT(*) AS count 
FROM tblSport AS s LEFT JOIN tblRespondentSport AS r 
ON s.pkSportID = r.fkSportID
GROUP BY s.pkSportID, s.fldSport

You are missing Group BY

SELECT s.pkSportID AS id, s.fldSport AS sport, COUNT(*) AS count 
FROM tblSport AS s LEFT JOIN tblRespondentSport AS r 
ON s.pkSportID = r.fkSportID
GROUP BY s.pkSportID, s.fldSport

回复收藏 0 原文