摘要： delete from userinfo where userinfo guid in (select guid from personinfo where departid = 部门id);//删除人员信息delete from personinfo where departid = 部门id;/... 阅读全文