UPDATE [변경될테이블]
SET [컬럼1] = A2.[컬럼1] , [컬럼2] = A2.[컬럼2]
FROM [조인테이블] A2
WHERE [변경될테이블].[조건컬럼] = A2.[조건컬럼]
출처: https://tjddnjs625.tistory.com/8 [seong.on2e:티스토리]
sunj
Posted on
SQL, 다른테이블과 JOIN하여 UPDATE
For further actions, you may consider blocking this person and/or reporting abuse
Top comments (0)