Samuel Neff wrote: > > Try this.. > > SELECT p.name, sum(s.stat1), sum(s.stat2) > FROM stats s JOIN Players p ON p.ID = s.playerID > WHERE s.gameID IN (SELECT gameID FROM games ORDER BY gameID DESC LIMIT 5) > GROUP BY p.playerID > > HTH, > > Sam >
This worked! Thanks for your help Sam. P Kishor-3, Thanks for your response as well but your query didn't get the expected result. -- View this message in context: http://www.nabble.com/Multiple-table-SELECT-help-tp15613178p15618678.html Sent from the SQLite mailing list archive at Nabble.com. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
