Cacher is the code snippet organizer for pro developers

SELECT *
  FROM 
    [dbo].[CMS_User] u
  INNER JOIN 
	  [dbo].[CMS_UserRole] ur
    ON 
  	  ur.UserID = u.UserID
  INNER JOIN 
	  [dbo].[CMS_Role] r
    ON
  	  r.RoleID = ur.RoleID
  INNER JOIN 
	  [dbo].[CMS_UserSite] us
    ON
      us.UserID = u.UserID
  INNER JOIN 
	  [dbo].[CMS_Site] s
    ON
      s.SiteID = us.SiteID