Cacher is the code snippet organizer for pro developers

SELECT p.Name AS PGU, s.SkillName AS Skill, qc.QuestionCategory  FROM dbo.SkillQuestionCategory sqc 
INNER JOIN dbo.QuestionCategories qc ON qc.QuestionCategoryId = sqc.QuestionCategoryId AND qc.IsActive = 1
INNER JOIN dbo.CenterXPGUXSkill cps ON cps.CenterXPGUXSkillId = sqc.CenterPguSkillId AND cps.IsActive = 1
INNER JOIN dbo.CenterXPGU cx ON cx.CenterXPGUId = cps.CenterXPGUId AND cx.IsActive = 1
INNER JOIN dbo.PGU p ON p.PGUId = cx.PGUId AND p.IsActive = 1
INNER JOIN dbo.Skill s ON s.SkillId = cps.SkillId AND s.IsActive = 1
WHERE sqc.IsActive = 1
ORDER BY  p.Name , s.SkillName , qc.QuestionCategory