Simple query, maybe not
Posted: Mon Aug 13, 2012 7:00 pm
Query
SELECT SUM(Team_entries.total_score)AS score, Team_entries.team_id, Team_entries.team_club, Team_entries.team_name, Team_entries.team_grade, Team_entries.total_score, Team_entries.Updated, Team_entries.Countback
FROM Team_entries
WHERE Team_entries.team_grade='BPB' OR Team_entries.team_grade='BPBS' AND team_name<>'Bye'
GROUP BY Team_entries.team_name
ORDER BY Countback ASC, score DESC
The query does what I want it to do except it will not exclude the team_name "AND team_name<>'Bye'"
Thank you in advance for any assistance you may be able to offer
SELECT SUM(Team_entries.total_score)AS score, Team_entries.team_id, Team_entries.team_club, Team_entries.team_name, Team_entries.team_grade, Team_entries.total_score, Team_entries.Updated, Team_entries.Countback
FROM Team_entries
WHERE Team_entries.team_grade='BPB' OR Team_entries.team_grade='BPBS' AND team_name<>'Bye'
GROUP BY Team_entries.team_name
ORDER BY Countback ASC, score DESC
The query does what I want it to do except it will not exclude the team_name "AND team_name<>'Bye'"
Thank you in advance for any assistance you may be able to offer