Update Query

  • Thread starter Thread starter Chris Savedge
  • Start date Start date
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'
 
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...
 
Back
Top