查询
来源：互联网 发布：python开发环境 编辑：程序博客网 时间：2024/06/11 15:41
select ModuleID, ModuleName from Module where ModuleID in (select distinct ModuleID from RolePurview where RoleID in(select RolesID from User_Role where UserID in (select UserID from Users where UserName='aaa')))
select * from Functions where ModuleID=1
