Invalid query : select pID, first, last, sum(gsKRAttempts) as KRs, sum(gsKRYards) as KRyds, sum(gsKRTDs) as KRtds, sum(gsPRAttempts) as PRs, sum(gsPRYards) as PRyds, sum(gsPRTDs) as PRtds from tecmoplayer, game_stats, tecmoteam where gslUID = 1 AND pID = gspUID AND tID = gsTeam AND gPlayoff = 0 AND gsfranchise = AND (pos = 1 OR pos = 2) AND (gsKRAttempts > 0 OR gsPRAttempts > 0) group by pID order by last asc