sql - db2: update multiple rows and field with a select on a different table - Stack Overflow

DB2 and the SQL standard don't have a FROM clause in an UPDATE statement. So you have to clearly separate the steps to identify the rows to be modified and to compute the new value.. Here is an example: UPDATE TABLE A SET A.FLD_SUPV = ( SELECT B ...

stackoverflow.com