JOIN UPDATE / DELETE

-- JOIN UPDATE
UPDATE ORDERS
SET OrderDate = getdate()
FROM ORDERS A INNER JOIN [ORDER DETAILS] B ON A.ORDERID = B.ORDERID
WHERE B.DISCOUNT > 0.1

-- JOIN DELETE
DELETE TABLE_MAIN
FROM TABLE_MAIN A
INNER JOIN TABLE_JOIN B ON A.SEQNUM = B.SEQNUM AND B.PROGBN = 'Y'

조인을 이용한 UPDATE/DELETE 구문이다.