SQL使用“AND”+“OR”语句加入(SQL Join with “AND” + “OR” statement)

 我遇到了这个SQL语句的问题。 我试图将结果限制为ID为'25'和'87'的玩家。 查询没有错误（我通过此查询得到每个PID）这是语句。 
 
SELECT Rosters.PID, SUM( Rosters.Goals ) Goals, SUM( Rosters.Assists ) Assists, SUM( Rosters.PIM ) PIM, Rosters.TID, Players.pid, Players.firstname, Players.lastname, 
       SUM((Rosters.Goals + Rosters.Assists)) AS Points, Teams.tid, Teams.teamname
       FROM Rosters
       INNER JOIN Players
       ON Rosters.PID = Players.pid
       INNER JOIN Teams 
       ON Rosters.TID = Teams.tid
       WHERE ((Rosters.TID BETWEEN 9 AND 16) AND (Players.pid = 25 OR 87))
       GROUP BY 
       Players.pid
       ORDER BY Points DESC
 
 我几乎可以肯定这是我缺乏SQL理解的原因，但W3C学校并没有提供更复杂的解决方案，我查找的Stack线程已经相当本地化。 
 
 这是当前的输出。 它应该是Id为25和87的玩家 

I am having trouble with this SQL statement. I am trying to restrict the results to the players with the ID's '25' and '87'. There is no error on the query ( I am getting every PID with this query) This is the statement. 
 
SELECT Rosters.PID, SUM( Rosters.Goals ) Goals, SUM( Rosters.Assists ) Assists, SUM( Rosters.PIM ) PIM, Rosters.TID, Players.pid, Players.firstname, Players.lastname, 
       SUM((Rosters.Goals + Rosters.Assists)) AS Points, Teams.tid, Teams.teamname
       FROM Rosters
       INNER JOIN Players
       ON Rosters.PID = Players.pid
       INNER JOIN Teams 
       ON Rosters.TID = Teams.tid
       WHERE ((Rosters.TID BETWEEN 9 AND 16) AND (Players.pid = 25 OR 87))
       GROUP BY 
       Players.pid
       ORDER BY Points DESC
 
I am almost certain this is the cause of my lack of SQL understanding, but W3C schools does not offer more complex solutions and the Stack threads I have looked up have been pretty localized. 
 
Here is the current output. It should just be the players with Id's 25 and 87

原文：https://stackoverflow.com/questions/35309028