Join Update

UPDATE a SET a.필드1 = b.필드1
FROM TABLE1 a INNER JOIN
            TABLE2 b on a.ID = b.ID
WHERE a.NO = 1