不用in,可以用exist。另外,这三张表的引用关系是什么? user --用户表 User_Roles --用户角色表 Role_Permission --用户权限
select MenuText from mainmenu a where exists (select * from Role_Permission b,User_Roles c,users d where a.PermissionID=b.PermissionID and b.RoleID=c.RoleID and c.userid=d.userid and d.userpkno=10)
mainmenu(PermissionID)--Role_Permission(PermissionID) Role_Permission (RoleID )--User_Roles (roleid ) User_Roles (userid)--users (id )
user --用户表
User_Roles --用户角色表
Role_Permission --用户权限
where exists
(select * from Role_Permission b,User_Roles c,users d
where a.PermissionID=b.PermissionID and b.RoleID=c.RoleID and c.userid=d.userid and d.userpkno=10)
Role_Permission (RoleID )--User_Roles (roleid )
User_Roles (userid)--users (id )