Cacher is the code snippet organizer for pro developers

SELECT u.EmpId
	,u.UserName
	,u.Email
	,p.Name AS PGU
	,s.SkillName
	,ucxps.Rating 
	,u.ManagerName
	,u.PrimaryRole
	,u.SecondaryRole
	,u.Country
	,u.FacilityDesc
	,u.ServiceTower
	,u.Region
FROM dbo.UserCenterXCenterPguSkill ucxps
INNER JOIN dbo.UserXCenter uc ON uc.UserXCenterId = ucxps.UserXCenterId
	AND uc.IsActive = 1
INNER JOIN dbo.[User] u ON u.UserId = uc.UserId
	AND u.IsActive = 1
INNER JOIN dbo.CenterXPGUXSkill cps ON cps.CenterXPGUXSkillId = ucxps.CenterXPGUXSkillId	AND cps.IsActive  =1
INNER JOIN dbo.Skill s ON s.SkillId = cps.SkillId AND s.IsActive = 1
INNER JOIN dbo.CenterXPGU cp ON cp.CenterXPGUId = cps.CenterXPGUId AND cp.IsActive = 1
INNER JOIN dbo.PGU p ON p.PGUId = cp.PGUId AND cp.IsActive = 1
WHERE ucxps.IsActive = 1
ORDER BY u.ManagerName, u.UserName,s.SkillName