AS/400 – iSeries SQL Update of on table with values from another joined table

AS/400 – iSeries SQL Update of on table with values from another joined table

瀏覽:758
日期:2025-04-25
I've use an SQL utility on the AS/400 call SEQUEL by ASC, that allows updating of values in one table from values in another joined table. The syntax is something like this: update set((a.fld1=b.fld1)(a.fld2=b.fld2)) from file1 a join file2 b on a.key1=b....看更多