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'
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'