advanced query

[C_Macca]

Gday to you all

hope someone can help, i have a query i need which i am not sure of

i have 2 tables

Table 1
PlayerID
PlayerName

Table2
Answer
QuestionID
MatchID

the query i need is to show Table1.PlayerName where

Table1.PlayerID = Table2.Answer
AND
Table2.QuestionID = 1
AND
Table2.MatchID = 1

can someone help me with this

Thanks

[cluksha]

SELECT Table1.PlayerID _User
FROM Table1 INNER JOIN Table2 ON Table1.PlayerID = Table2.Answer
WHERE Table2 .QuestionID = 1 AND Table2 .MatchID = 1

I hope this helps
Chris