UPDATE [변경될테이블]
SET [컬럼1] = A2.[컬럼1] , [컬럼2] = A2.[컬럼2]
FROM [조인테이블] A2
WHERE [변경될테이블].[조건컬럼] = A2.[조건컬럼]
출처: https://tjddnjs625.tistory.com/8 [seong.on2e:티스토리]
SQL, 다른테이블과 JOIN하여 UPDATE
sunj - Sep 3 - sunj - Sep 3 - sunj - Sep 3 - UPDATE [변경될테이블]
SET [컬럼1] = A2.[컬럼1] , [컬럼2] = A2.[컬럼2]
FROM [조인테이블] A2
WHERE [변경될테이블].[조건컬럼] = A2.[조건컬럼]
출처: https://tjddnjs625.tistory.com/8 [seong.on2e:티스토리]
