| How to sum values on individual records? [message #191128] |
Mon, 04 September 2006 22:57  |
bigtoque
Messages: 2
Registered: September 2006
|
Junior Member |
|
|
I'm having a hell of a time trying to get this to work and I'm sure it's a relatively simple solution...
I'm managing the stats for my hockey team and in this particular select statement, I'm trying to sort the top point scorers in a single game.
IE, I have 1 player right now who holds positions #1 and #3 for most points in a single game, but my code sums the points from every game he's played in.
SELECT players.PID PID, players.f_Name fName, players.l_Name lName, SUM (player_stats.G + player_stats.A) PTS
FROM players, player_stats
WHERE players.PID = player_stats.PID
AND year = 2005
AND league = 'Spring'
GROUP BY players.PID ORDER BY PTS DESC
How can I modify this so that G and A are summed on only single records, and not all the records?
|
|
|
|
|
|
| Re: How to sum values on individual records? [message #191134 is a reply to message #191128] |
Tue, 05 September 2006 00:15  |
hobbes
Messages: 173
Registered: January 2006
|
Senior Member |
|
|
If the scores have to be added for individual records only, then you don't need the SUM and GROUP BY at all. Does this work for you?
SELECT players.PID PID, players.f_Name fName, players.l_Name lName, (player_stats.G + player_stats.A) PTS
FROM players, player_stats
WHERE players.PID = player_stats.PID
AND year = 2005
AND league = 'Spring'
ORDER BY PTS DESC |
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
