好吧，您确实需要SUM这些列（这SUM是一个聚合函数，这就是为什么要在GROUP BY那儿使用）。为了更好地编写查询，您需要丢失旧的隐式JOIN样式，并使用ANSI显式样式：
SELECT game.mdate,
game.team1,
SUM(CASE WHEN goal.teamid=game.team1 THEN 1 ELSE 0 END) score1,
game.team2,
SUM(CASE WHEN goal.teamid=game.team2 THEN 1 ELSE 0 END) score2
FROM game
INNER JOIN goal
ON game.id=goal.matchid
GROUP BY game.mdate, goal.matchid, game.team1, game.team2
602392714
清零编程群