sql server 的级联删除

delete PRJ项目权限表 from SYS用户 as A1 RIGHT JOIN PRJ项目权限表 as A2
ON A1.ID = A2.用户ID  where A1.ID IS NULL

 

delete A1 from A1,  A2 where A1.对象ID=A2.ID and A2.版本ID = ?