Invalid query : select pID, first, last, sum(gsRushes) as Rushes, sum(gsRushYards) as RushYards, sum(gsRushYards)/sum(gsRushes) as AvgRush, sum(gsRushTDs) as RushTDs, sum(gsReceptions) as recs, sum(gsReceptionYards) as recyds, sum(gsReceptionTDs) as rectds from tecmoplayer, game_stats, tecmoteam where gslUID = 1 AND pID = gspUID AND tID = gsTeam AND gPlayoff = 0 AND gsfranchise = AND pos = 1 AND gsRushes > 0 group by pID order by last asc