Invalid query : select pID, first, last, sum(gsRushes) as Rushes, sum(gsRushYards) as RushYards, sum(gsRushYards)/sum(gsRushes) as AvgRush, sum(gsRushTDs) as RushTDs , tID, city, tname, dod from tecmoplayer, game_stats, tecmoteam where pID = gspUID AND tID = gsTeam AND gsSeason = AND gslUID = 1 AND gPlayoff = 0 AND (pos = 1 OR pos = 2) AND gsRushes > 0 group by pID, gsSeason order by gsRushYards desc