JOIN 후 UPDATE (조인한 후에 업데이트)

CREATE TABLE #T_AAA
(
  V_KEY VARCHAR(20)
  ,V_A VARCHAR(20)
)

CREATE TABLE #T_BBB
(
  V_KEYVARCHAR(20)
  ,V_B VARCHAR(20)
)

INSERT INTO #T_AAA VALUES ('AB1', 'AA');
INSERT INTO #T_BBB VALUES ('AB1', 'BB');

 UPDATE A
    SET A.V_A = B.V_B
   FROM #T_AAA A
  INNER JOIN #T_BBB B ON B.V_KEY = A.V_KEY;
 
 SELECT * FROM #T_AAA;
 SELECT * FROM #T_BBB;

 

DROP TABLE #T_AAA
DROP TABLE #T_BBB