Comparrisons

[yammers4]

I have created a query called test this has all the players name is and results, Im trying to create from this query another query that will allow me to type in two different player names to compare there results. having bit dificulty doing this. see attached. Or would it be better with two seperate querys.

 

[Taruz]

Hi yammers4

Compare these two players to the query..:

select 
   MatchDate
  ,Team
  ,PlayerFirstName
  ,PlayerLastName
  ,OurScore
  ,OppositionScore
from test
where PlayerFirstName=[Enter 1 Player Name] or PlayerFirstName=[Enter 2 Player Name]
order by PlayerLastName

 

[yammers4]

I have tried this but could you give a bit more detail in what i need to do please as it does not seem to work, do i create two querys to start with please give more detailed instructions.