Cacher is the code snippet organizer for pro developers

SELECT atm.NAME,atm.AnswerType
	,hmSection.Id AS SectionId
	,hmSection.NAME AS SectionName
	,hmSubSection.Id AS SubSectionId
	,hmSubSection.NAME AS SubSectionName
	,hmGroup.Id AS GroupId
	,hmGroup.NAME AS GroupName
	,qm.QuestionText
FROM AuditTypeXQuestion atq
INNER JOIN AuditTypeMaster AS atm ON atm.Id = atq.AuditTypeId
INNER JOIN QuestionMaster qm ON qm.Id = atq.QuestionId
INNER JOIN HierarchyMaster hmGroup ON qm.HIERARCHYID = hmGroup.Id
INNER JOIN HierarchyMaster hmSubSection ON hmSubSection.Id = hmGroup.ParentId
INNER JOIN HierarchyMaster hmSection ON hmSection.Id = hmSubSection.ParentId
ORDER BY atm.NAME
	,hmSection.Id
	,hmSubSection.Id
	,hmGroup.Id