Update JOIN, DELETE JOIN

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.ID
WHERE ....