Cacher is the code snippet organizer for pro developers

SELECT p.NAME PGU
	,s.SkillName
	,dbo.UFN_GetATPNameByATPId(qual.AtpId) ATP
	,qc.NAME AS Complexity
	,qual.RequiredQuestionCount
	,qual.AvailableQuestionCount
	,qual.CreatedBy
FROM dbo.QuestionUnAvailabilityLog qual
LEFT JOIN dbo.PGU p ON qual.PguId = p.PGUId
LEFT JOIN dbo.Skill s ON s.SkillId = qual.SkillId
LEFT JOIN dbo.ActivityXTypeXPortfolio atp ON atp.ActivityXTypeXPortfolioId = qual.AtpId
LEFT JOIN dbo.QuestionComplexity qc ON qc.QuestionComplexityId = qual.ComplexityId