MSSQL
JOIN 절 활용한 UPDATE 구문
돕니
2018. 1. 9. 11:29
UPDATE A
SET 컬럼 = B.컬럼
FROM 테이블1 AS A INNER JOIN 테이블2 AS B
ON A.컬럼 = B.컬럼
WHERE ISNULL(A.컬럼, '') <> ISNULL(B.컬럼, '')