update join

UPDATE 테이블명1
SET
[컬럼명1] = B.컬럼명1
,[컬럼명2] = B.컬럼명2
,[컬럼명3] = B.컬럼명3
FROM 테이블명1 AS A
INNER JOIN (SELECT 컬럼명1 AS 컬럼명1
,컬럼명2 AS 컬럼명2
,컬럼명3 AS 컬럼명3
FROM 테이블명1) AS B
ON A.컬럼명 = B.컬럼명

 

 

update Data1
set DataValue = DataValue + (2000 * B.Cnt)
from Data1 A

JOIN Data2 B ON A.Idx = B.Idx
where B.range = 1

 

뭐 그렇다는거!