wooi
Active Member
I am trying to update a table (DB2) while joining to a second table, but getting "Keyword JOIN not expected". Can someone suggest proper syntax? Thank you.
update testdta/f060120 es set es.yajbcx='test'
join testdta/f060116 em
on em.yaan8=es.yaan8
where em.yapst<>0
update testdta/f060120 es set es.yajbcx='test'
join testdta/f060116 em
on em.yaan8=es.yaan8
where em.yapst<>0