中指定MatchID所属的表
指定字段为MatchID
。我不知道怎么修理它。我试过在GROUP BY
之后将tblPlayerStatistics
添加到MatchID
,但没有奏效。
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;
你也可以用using
子句来解决这个问题:
SELECT ps.Player_ID_Number,
SUM(ps.TwoPointerMade + ps.ThreePointerMade) AS points,
MatchID
FROM tblPlayerStatistics ps INNER JOIN
tblGameResults gr
USING (MatchId)
GROUP BY ps.Player_ID_Number, MatchID;
我还引入了表别名(缩写),以使查询更具可读性。
你的查询应该是这样的
SELECT tps.Player_ID_Number,
SUM(tps.TwoPointerMade + tps.ThreePointerMade) AS points,
tps.MatchID <-- Here refer the table where MatchID taken
FROM tblPlayerStatistics tps INNER JOIN tblGameResults tgr
ON tps.MatchID = tgr.MatchID
GROUP BY tps.Player_ID_Number,tps.MatchID; <--So does Here
Try
SELECT tblPlayerStatistics.Player_ID_Number,
SUM(tblPlayerStatistics.TwoPointerMade + tblPlayerStatistics.ThreePointerMade) AS points,
tblPlayerStatistics.MatchID
FROM tblPlayerStatistics
INNER JOIN tblGameResults ON tblPlayerStatistics.MatchID = tblGameResults.MatchID
GROUP BY tblPlayerStatistics.Player_ID_Number, tblPlayerStatistics.MatchID;
您需要在GROUP BY