SQL JOIN Statement on AS400

[tboston]

I am trying to run the following SQL query on an AS400:

update cdbtstd_aa16nt
set cdbtstd_aa16nt.aa1qa = (aa1aqa + ' ' + aa1ara + ' ' + aa1asa)
from istestlib_psr0104 inner join cdbtstd_aa16nt
on cdbtstd_aa16nt.aaefa = istestlib_psr0104.aaefa
and cdbtstd_aa16nt.aaama = istestlib_psr0104.aaama
and cdbtstd_aa16nt.aaeba = istestlib_psr0104.aaeba
and cdbtstd_aa16nt.aa1aoa = istestlib_psr0104.aa1aoa

When checked in SQL server the query parses correctly leading me to believe that the syntax is correct. However, when I run the query on the AS400 I get the following error message:&quot;Keyword FROM not expected. Valid tokens: <END-OF-STATEMENT>&quot;

Anyone have any thoughts regarding running this query on an AS400?

Thanks,
tb

 

[fluteplr]

I would suggest posting this on the Ansi SQL forum or an AS400 forum if there is one. This is for Microsoft SQL Server.

 

[tboston]

I'll try that...sorry for the mis-posting.

 

[fluteplr]

No need to apologise I just figured you would be more likely to get an answer.