批量更新sql

UPDATE TABLE_1 
    SET COL_1=TT2.RESULT_COL_1,COL_2=TT2.RESULT_COL_2
FROM TABLE1 AS TT1
INNER JOIN (SELECT RESULT_COL_1,RESULT_COL_2 FROM TABLE_2) AS TT2
ON TT2.RELATION_COL=TT1.RELATION_COL