WEB/MSSQL
[MSSQL] 테이블 조인하여 UPDATE/DELETE 쿼리
인생시계
2020. 12. 10. 10:00
[MSSQL] 테이블 조인(JOIN)하여 UPDATE/DELETE 쿼리
UPDATE TABLE_A
SET COLUMN_A = TB.COLUMN_B
FROM TABLE_A TA
INNER
JOIN TABLE_B TB
ON TA.SEQ= TB.SEQ
WHERE ....
DELETE FROM TABLE_A
FROM TABLE_A
INNER
JOIN TABLE_B TB
ON TA.SEQ = TB.SEQ
WHERE TA.COLUMN_A = TB.COLUMN_B