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

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

瀏覽:619
日期:2025-11-19
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 ......看更多