2007. 11. 14. 16:10
UPDATE a SET a.필드1 = b.필드1
FROM TABLE1 a INNER JOIN
TABLE2 b on a.ID = b.ID
WHERE a.NO = 1
'Database/ANSI-SQL'에 해당되는 글 1건
- 2007.11.14 Join Update
- Total
- Today
- Yesterday
욥과같이
UPDATE a SET a.필드1 = b.필드1
FROM TABLE1 a INNER JOIN
TABLE2 b on a.ID = b.ID
WHERE a.NO = 1