三张表通过用户名查角色名称和权限

select u.UserID, LoginName,LoginPassword,RoleName  
from [CF_User] u  join [CF_UserRole] ur
     on u.UserID=ur.UserID join [CF_Role] r
     on ur.RoleID=r.RoleID

 

select u.UserID, u.LoginName,p.PrivilegeAccess,p.PrivilegeAccessValue,p.PrivilegeOperation
from [CF_User] u join [CF_UserRole] ur
     on u.UserID=ur.UserID
     join [CF_Privilege] p
     on ur.RoleID=p.PrivilegeMasterValue
     order by Userid asc