2 INNER JOINS return Syntax error 1

[russland]

Hi

If I run only the whole query with 1st INNER JOIN, only, it works fine. When I append the second INNER JOIN (see below) it would return an error: Syntax error(missing operator) in query expression 'A.ProjectID = P.ProjectID
INNER JOIN ConstructionStatuses ON P.ConstructionStatusID = ConstructionStatuses.ID'
Do I need a delimiter between the 2 JOINS? I'm using MsAccess.

My Query
-----------------
INNER JOIN Projects AS P ON A.ProjectID = P.ProjectID
INNER JOIN ConstructionStatuses ON P.ConstructionStatusID = ConstructionStatuses.ID

Any hints highly welcome

Cheers

 

[PHV]

MsAccess (in fact JetSQL) syntax:
FROM [!]([/!]yourTable AS A
INNER JOIN Projects AS P ON A.ProjectID = P.ProjectID[!])[/!]
INNER JOIN ConstructionStatuses ON P.ConstructionStatusID = ConstructionStatuses.ID

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[russland]

My query was so complex and stuffed with subqueries that I set the begining parantheses after the wrong FROM (since I saw that answer from you in another thread). I let the designer do it and he did it well - and as you suggested. thanks heaps