How to resolve MS Access SQL UPDATE syntax error

Question

I am trying to type a SQL query in MS Access to update the records in FilesTable.FilePath with the records in Files.FPath, when the FilesTable.FileName Matches a record in Files.FName, but I receive an error:

UPDATE FilesTable
SET FilesTable.[FilePath] = Files.[FPath]
FROM (FilesTable INNER JOIN Files ON (FilesTable.[FileName] = Files.[FName])
WHERE *;

syntax error (missing operator) in query expression 'Files.[FPath] FROM (FilesTable INNER JOIN Files ON (FilesTable.[FileName] = Files.[FName]) WHERE *;'

I have also tried to add () after Set as well which results in an error as well:

UPDATE FilesTable
SET (FilesTable.[FilePath] = Files.[FPath])
FROM (FilesTable INNER JOIN Files ON (FilesTable.[FileName] = Files.[FName])
WHERE *;

Syntax Error in UPDATE Statement.

Here is how my tables looks like

Unhandled Exception Unhandled Exception · Accepted Answer · 2018-11-14T14:52:03

This is the correct query:

UPDATE FilesTable
INNER JOIN Files ON (FilesTable.FileName = Files.FName)
SET FilesTable.FilePath = Files.FPath

How to resolve MS Access SQL UPDATE syntax error

1 Answers