【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.. --UPDATE中INNER JOIN操作 UPDATE A SET field='xxx'