LEFT JOIN - Syntax error in FROM clause

  • Thread starter Thread starter Igor
  • Start date Start date
I

Igor

Hello,

Please, can somebody help me out?

I'm getting a "Syntax error in FROM clause" message:

SELECT [Deliverables Index].[Project File], [Deliverables Index].Title,
[Deliverables Index].[Document Number], [To ACP].Revision, [To ACP].[Date
Sent], [To ACP].[Reply Received], [To ACP].[ACP Reference Number],
DateDiff("d",[To ACP].[Date Sent],NZ([From ACP].[Date Received],Date())) AS
[Days], [From ACP].[Date Received]
FROM ([Deliverables Index] LEFT JOIN [To ACP] ON [Deliverables
Index].[Document Number] = [To ACP].[Document Number])
[To ACP] LEFT JOIN [From ACP] ON [To ACP].[ACP Reference Number] = [From
ACP].[ACP Reference Number];

I would appreciate all the help I could get.
 
Solved!

SELECT [Deliverables Index].[Project File], [Deliverables Index].Title,
[Deliverables Index].[Document Number], [To ACP].Revision, [To ACP].[Date
Sent], [To ACP].[Reply Received], [To ACP].[ACP Reference Number],
DateDiff("d",[To ACP].[Date Sent],NZ([From ACP].[Date Received],Date())) AS
Days, [From ACP].[Date Received]
FROM [Deliverables Index] LEFT JOIN ([To ACP] LEFT JOIN [From ACP] ON [To
ACP].[ACP Reference Number]=[From ACP].[ACP Reference Number]) ON
[Deliverables Index].[Document Number]=[To ACP].[Document Number];

Thanks anyway!
 
There is a [To ACP] that should not be there, in the FROM clause:


FROM ([Deliverables Index] LEFT JOIN [To ACP] ON [Deliverables
Index].[Document Number] = [To ACP].[Document Number])
[To ACP] LEFT JOIN [From ACP] ON [To ACP].[ACP Reference Number] = [From
ACP].[ACP Reference Number];


Vanderghast, Access MVP
 
Igor said:
I'm getting a "Syntax error in FROM clause" message:

SELECT [Deliverables Index].[Project File], [Deliverables Index].Title,
[Deliverables Index].[Document Number], [To ACP].Revision, [To ACP].[Date
Sent], [To ACP].[Reply Received], [To ACP].[ACP Reference Number],
DateDiff("d",[To ACP].[Date Sent],NZ([From ACP].[Date Received],Date())) AS
[Days], [From ACP].[Date Received]
FROM ([Deliverables Index] LEFT JOIN [To ACP] ON [Deliverables
Index].[Document Number] = [To ACP].[Document Number])
[To ACP] LEFT JOIN [From ACP] ON [To ACP].[ACP Reference Number] = [From
ACP].[ACP Reference Number];
Click to expand...


You have an extraneous [To ACP] before the second LEFT JOIN
 
Thank you very much!


--

igor


Marshall Barton said:
Igor said:
I'm getting a "Syntax error in FROM clause" message:

SELECT [Deliverables Index].[Project File], [Deliverables Index].Title,
[Deliverables Index].[Document Number], [To ACP].Revision, [To ACP].[Date
Sent], [To ACP].[Reply Received], [To ACP].[ACP Reference Number],
DateDiff("d",[To ACP].[Date Sent],NZ([From ACP].[Date Received],Date())) AS
[Days], [From ACP].[Date Received]
FROM ([Deliverables Index] LEFT JOIN [To ACP] ON [Deliverables
Index].[Document Number] = [To ACP].[Document Number])
[To ACP] LEFT JOIN [From ACP] ON [To ACP].[ACP Reference Number] = [From
ACP].[ACP Reference Number];
Click to expand...


You have an extraneous [To ACP] before the second LEFT JOIN
Click to expand...
 
Back
Top