Problem with SQL Query

Results 1 to 2 of 2

Thread: Problem with SQL Query

  1. #1
    Join Date
    Dec 1969

    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
    Nils Bilhorn Guest

    Default RE: Problem with SQL Query

    The only thing that comes to mind is that the word module is reserved in ANSI SQL. I&#039;ve tested it (with the name module exchanged) and it worked on the dbms I&#039;m using.

Posting Permissions

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