[MSSQL] UPDATE 활용

UPDATE A

SET AA = B.AA

FROM TABLE1 A, TABLE2 B

WHERE A.BB = B.BB

    AND A.CC = '22'

    AND B.DD = 'TEST'

 

 

UPDATE TABLE1 A

SET AA = (SELECT BB FROM TABLE2 B WHERE A.AA = B.AA)

WHERE A.CC = '22'

    AND A.DD = (SELECT FF FROM TABLE2 B WHERE C='1234')