MS-SQL

Join절 Update

Dayis 2011. 11. 3. 10:54
UPDATE T1 SET
T1.TITLE='TITLE'
,T1.MESSAGE='MESSAGE'
FROM
TABLE T1 INNER JOIN TABLE=T2 ON T1.CODE=T2.CODE
WHERE
T1.LAGNUAGE='KR' AND T2.SITE='JP'
저작자표시 비영리 변경금지 (새창열림)