SQL Syntax Error

[polisasimo]

Hello Everyone,



I am trying to update records from another table. I am using this thread as an example:

http://stackoverflow.com/questions/2...=votes#tab-top

With this SQL:

UPDATE
Sales_Import
SET
Sales_Import.AccountNumber = RAN.AccountNumber
FROM
Sales_Import SI
INNER JOIN
RetrieveAccountNumber RAN
ON
SI.LeadID = RAN.LeadID


After transcribing the SQL to meet my schema:

UPDATE
Master_chapter
SET
Master_chapter.Revision = Pending_Revisions.Revision
FROM
Master_chapter MC
INNER JOIN Pending_Revisions PR
ON
MC.ID = PR.Master_Chapter_Index

I keep getting the following error on my VB code line: CurrentDb.Execute SQL, dbFailOnError

Syntax error (missing operator) in query expression
'UPDATE Master_chapter SET Master_chapter.Revision = Pending_Revisions.Revision FROM Master_chapter MC INNER JOIN
Pending_Revisions PR ON MC.ID = PR.Master_Chapter_Index'.

Any ideas on where the syntax for the SQL is wrong would be greatly appreciated. It seems the "ON MC.ID = PR.Master_Chapter_Index" should be right?

Thanks

[polisasimo]

Tried this seems to work better:

UPDATE Master_chapter INNER JOIN Pending_Revisions ON Master_chapter.ID = Pending_Revisions.Master_Chapter_Index SET Master_chapter.Revision = Pending_Revisions.Revision