On 2/21/08, RBKanso <[EMAIL PROTECTED]> wrote:
>
> Assume the following table structure:
>
> http://www.nabble.com/file/p15613178/sbtables.jpg
>
> I can get overall player stats for ALL games using this select statement:
>
> SELECT p.name, sum(s.stat1), sum(s.stat2)
> FROM stats s JOIN Players p ON p.ID = s.playerID
> GROUP BY p.ID
>
> And I can get a summary of stats for the last FIVE games with this call:
>
> SELECT g.date, g.opponent, g.result, sum(s.stat1), sum(s.stat2)
> FROM stats s JOIN games g ON g.ID = s.gameID
> GROUP BY g.ID
> ORDER BY g.date DESC
> LIMIT 0,5
>
> But how would I get the overall PLAYER stats for the last FIVE games?
>
try
SELECT player_id, player_name, Sum(stat1), Sum(stat2)
FROM
SELECT p.ID AS player_id, p.name AS player_name,
s.stat1 AS stat1, s.stat2 AS stat2,
g.date AS game_date
FROM stats s JOIN
players p on p.ID = s.playerID JOIN
games g ON g.ID = s.gameID
ORDER BY g.date DESC
LIMIT 0,5
GROUP BY player_id, player_name
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
