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