SELECT
player.FirstName,
player.LastName,
team.teamName,
TotalPoints,
TotalRebounds,
TotalAssists,
TotalSteals,
TotalBlocks
FROM playerstats
INNER JOIN player
ON playerstats.PlayerID = player.PlayerID
我有一个称为玩家的表(玩家ID,名字,姓氏,团队ID)
名为Team(teamID,teamName)的表。我有一个名为playerstat(具有playerID)的表
我想列出名字,姓氏和球队以及总得分,篮板等
我想使用玩家ID来获取球队ID,然后列出球队名称...如果可以的话。不知道该怎么做。
最佳答案
在您的问题中,您不会指出playerstats表是否每个球员都有多行,也不会指出team表的列可能是什么,而是假设playerstats表每个球员都有多行,并且您有一个团队表,您可以尝试一下。您将需要替换正确的列名称:
SELECT
player.FirstName,
player.LastName,
team.teamName,
sum(points) as TotalPoints,
sum(rebounds) as TotalRebounds,
sum(assists) as TotalAssists,
sum(steals) as TotalSteals,
sum(blocks) as TotalBlocks
FROM playerstats
INNER JOIN player
ON playerstats.PlayerID = player.PlayerID
JOIN team
ON team.id = player.teamID
GROUP BY player.FirstName, player.LastName,team.teamName
ORDER BY player.FirstName, player.LastName,team.teamName;