db2 sql update join的相關文章
SQL: Update with Subquery - Philipz學習日誌

SQL: Update with Subquery - Philipz學習日誌

瀏覽:1277
日期:2026-04-18
UPDATE Table D SET COL1 = A.COL2 WHERE exists (SELECT 1 FROM Table A INNER JOIN Table B ON A.KEY = B.KEY WHERE (B.TITCOD = 'A232 ' OR B.TITCOD = 'A233 ' OR B.TITCOD = 'A243 ' OR B.TITCOD = 'A9427 ') AND D.KEY = A.KEY) AND D ......看更多