MS Access SQL Syntax Error

Question

I'm trying to update a microsoft access database table field from a similar field in a linked table.

Here are my table names:

Raw data
sectionroster

And here's my query so far:

UPDATE [raw data].[current supervisor]
FROM [raw data] 
INNER JOIN [sectionroster] ON [raw data].[associate id]=[sectionroster].[employee number]
SET [raw data].[Current Supervisor] = [sectionroster].[supervisor];

It's giving me a syntax error referencing the from clause, and I can't figure out why. Any help would be appreciated!

Vinay · Accepted Answer · 2011-09-26 15:35:46Z

0

Try this

UPDATE [raw data].[current supervisor]
SET [raw data].[Current Supervisor] = [sectionroster].[supervisor]
FROM [raw data] 
INNER JOIN [sectionroster] ON [raw data].[associate id]=[sectionroster].[employee number]

answered Sep 26, 2011 at 15:35

Vinay

1,0648 silver badges22 bronze badges

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

7 Comments

Vinay Over a year ago

No problem. Did it work? If so, please accept the answer so that it helps the others.

user965323 Over a year ago

Thanks for the fast response! However, its giving me the exact same error! Is it possible that I some how have the relationship wrong between the 2 tables? I have [raw data].[associate id] directly linked to [sectionroster].[employee number]. and this is the only relationship existing on either table. Thanks again! JD

Vinay Over a year ago

The query looks about right. I found another question on stack overflow. May be this could help you solve the problem. stackoverflow.com/questions/537161/…

user965323 Over a year ago

Thanks again, Vinay! I just figured it out!

user965323 Over a year ago

This is what worked for me! UPDATE [raw data] inner join [sectionroster] ON [raw data].[associate id]=[sectionroster].[employee number] SET [raw data].[Current Supervisor] = [sectionroster].[supervisor] ;

|

Collectives™ on Stack Overflow

MS Access SQL Syntax Error

1 Answer 1

7 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

7 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related