Re: SQL UPDATE using INNER JOIN?

[Ron Adams <rondadams@xxxxxxxxx>]

To be more specific, I'm trying to do the equivalent of this on the iSeries:


update table1
   set fldX = T2.fldY
  from table1 T1
inner
  join table2 T2
    on T1.keyfld = T2.keyfld






On 1/16/06, Ron Adams <rondadams@xxxxxxxxx> wrote:
>
> I'm trying to don an UPDATE to a table using data from another table and
> using the INNER JOIN clause. Can anyone show me a working example of this
> because I can't seem to get it right.
>
>