【T-SQL】UPDATE和DELETE操作中使用INNER JOIN关联

--UPDATE中INNER JOIN操作
UPDATE A SET field='xxx' FROM table1 A INNER JOIN table2 B ON A.id=B.fkid WHERE..

--DELETE中INNER JOIN操作
DELETE FROM A FROM table1 A INNER JOIN table2 B ON A.id=B.fkid WHERE..

转载于:https://www.cnblogs.com/ronli/archive/2011/06/24/2088682.html