'2018/06/28'에 해당되는 글 1건
- 2018.06.28 Update JOIN, DELETE JOIN
2018. 6. 28. 14:09
Update JOIN, DELETE JOIN
2018. 6. 28. 14:09 in 팁&테크/MSSQL
UPDATE TableA (또는 Alias이름) SET foo = B.bar FROM TableA A INNER JOIN TableB B ON A.col1 = B.colx WHERE ...
DELETE TableA (또는 Alias이름)
FROM TableA A
INNER JOIN TableB B ON A.ID=B.IDWHERE ....