1 Reply Latest reply on Nov 9, 2006 5:35 AM by cluksha

    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