SQL statement - syntax error

Results 1 to 3 of 3

Thread: SQL statement - syntax error

  1. #1
    Wexie Guest

    Default SQL statement - syntax error

    I am trying to make an SQL statement involving 3 tables (one of which (Centres) is an intermediate table linking the other two.<BR><BR>I get "Syntax error in FROM clause..." It works OK in Access. Any ideas? <BR><BR>strSQL = "SELECT Person.Password, ProjServices.ProjectID " & _ <BR>"FROM (Centres INNER JOIN Person ON Centres.CentreID = Person.CentreID) " & _ <BR>"INNER JOIN ProjServices ON Centres.CentreID = ProjServices.CentreID " & _<BR>"WHERE ProjServices.ProjectID=" & intProjID & ""

  2. #2
    Join Date
    Dec 1969

    Default RE: SQL statement - syntax error

    You don&#039t state which database you are using, but I assume it is SQL Server. If so, why not plug this into the Query Analyzer and see what it says?

  3. #3
    Wexie Guest

    Default It works in Access...

    I use Access and its working fine there...

Posting Permissions

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