mysql - 查询表达式 'tblPlayerstatistics.MatchID = tblGameResults.MatchID COUNT tblPLayerStatistics.TwoPOinterMad.' 中存在语法错误(缺少运算符)

Question

我正在尝试通过选择在一场比赛中得分最高的球员来选择比赛的球员。我尝试将 2 分球命中数和 3 分球命中数相加，这是找出最高分的唯一方法。请帮忙ppp

SELECT tblPlayerStatistics.Player_ID_Number,
tblPlayerStatistics.TwoPointerMade,
tblPlayerStatistics.ThreePointerMade, 
MatchID
FROM tblPlayerStatistics
INNER JOIN tblGameResults ON tblPlayerStatistics.MatchID = tblGameResults.MatchID
COUNT tblPlayerStatistics.TwoPointerMade 
AND tblPlayerStatistics.ThreePointerMade
GROUP BY tblPlayerStatistics.Player_ID_Number;

Answer 1

您完全误解了 COUNT 的工作原理和 MySQL 的查询语法。如果您想将获得的积分数量相加，则需要使用 SUM。

您想要的查询是:

SELECT
    tblPlayerStatistics.Player_ID_Number,
    SUM(tblPlayerStatistics.TwoPointerMade + tblPlayerStatistics.ThreePointerMade) AS points, 
    MatchID
FROM
    tblPlayerStatistics
    INNER JOIN tblGameResults ON tblPlayerStatistics.MatchID = tblGameResults.MatchID
GROUP BY
    tblPlayerStatistics.Player_ID_Number,
    MatchID;

这应该会让你走上正确的道路