update select db2的相關文章
update select db2的相關公司資訊
update select db2的相關商品

sql - db2: update multiple rows and field with a select on a different table - Stack Overflow
瀏覽:1304
日期:2025-06-08
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 ......看更多