【TSQL】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..