[MS-SQL] 다른 TABLE과 JOIN UPDATE

UPDATE _table1 SET

_colume = B._colume

FROM _table1 A JOIN _table2 B ON A.col = B.col

WHERE A.COL > 1