SQL: Update with Subquery - Philipz學習日誌

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 ...

server.everfine.com.tw