Problem with SQL Query

Results 1 to 2 of 2

Thread: Problem with SQL Query

  1. #1
    Join Date
    Dec 1969
    Posts
    49

    Default Problem with SQL Query

    Can anyone tell me what&#039;s wrong with the following SQL Wuery.It keeps telling me there is an operator missing????<BR><BR>Select * From LiveTest <BR>Inner Join Questions ON LiveTest.Module = Questions.Module AND LiveTest.Topic = Questions.Topic AND LiveTest.SubTopic = Questions.SubTopic<BR>Inner Join Answers ON Questions.QuestionID = Answers.QuestionID;

  2. #2
    Join Date
    Dec 1969
    Posts
    19,082

    Default try this

    Select * From (LiveTest <BR>Inner Join Questions ON LiveTest.Module = Questions.Module AND LiveTest.Topic = Questions.Topic AND LiveTest.SubTopic = Questions.SubTopic)<BR>Inner Join Answers ON Questions.QuestionID = Answers.QuestionID;

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •