Update Query

C

Chris Savedge

I'm having a problem with the below Update Query. I'm getting an error
message that tells me there is a syntax error by the key word Inner. Can
someone help?

UPDATE proddta.F4072 INNER JOIN proddta.F4094 ON proddta.F4072.ADICID =
proddta.F4094.KIICID SET proddta.F4072.ADFVTR = 146800
WHERE proddta.F4072.ADFVTR =169900 AND proddta.F4072.ADEXDJ =110365 AND
proddta.F4094.KIPRGR = '430'
 
K

Kevin3NF

UPDATE proddta.F4072
SET proddta.F4072.ADFVTR = 146800
From proddta.F4072 INNER JOIN proddta.F4094 ON proddta.F4072.ADICID =
proddta.F4094.KIICID
WHERE proddta.F4072.ADFVTR =169900
AND proddta.F4072.ADEXDJ =110365
AND proddta.F4094.KIPRGR = '430'

Check that...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

HELP! UPDATE syntax that work in sql server and access vba 2
perform INNER JOIN on query results 2
ADP Update Query does NOT update ! 3
What makes a query updateable? 2
Inner Join with queries 2
Access Update Join 0
Runtime 3061: Too Few Parameters on nested query 1
Update Query 10

Top