Nhật ký học tập

SELECT R.RoleName, U.UserName, C.Path FROM Catalog C WITH (NOLOCK) --Parent JOIN Policies P WITH (NOLOCK) ON C.PolicyID = P.PolicyID JOIN PolicyUserRole PUR WITH (NOLOCK) ON P.PolicyID = PUR.PolicyID JOIN Users U WITH (NOLOCK) ON PUR.UserID = U.UserID JOIN Roles R WITH (NOLOCK) ON PUR.RoleID = R.RoleID WHERE C.Type = 1