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

AHeyne · Accepted Answer · 2018-11-14 14:59:00Z

0

This is the correct query:

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

edited Nov 14, 2018 at 14:59

answered Nov 14, 2018 at 14:52

AHeyne

3,5052 gold badges13 silver badges20 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

Ve3lst Over a year ago

I get "Syntax Error in UPDATE Statement." again

Ve3lst Over a year ago

lol i just did that and came here to say this is what i did, thanks man

Collectives™ on Stack Overflow

How to resolve MS Access SQL UPDATE syntax error

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related