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.COL1 <> D.COL2
SQL: Update with Subquery
No TrackBacks
TrackBack URL: http://server.everfine.com.tw/blog/mt-tb.cgi/309
