Cacher is the code snippet organizer for pro developers

SELECT asd.AuditTypeId, asd.HierarchyNodeId, asd.Weightage,hmSubSection.NAME hmSubSection, hmSection.NAME hmSection
FROM dbo.AuditTypeXSubsectionWeightage asd
INNER JOIN dbo.HierarchyMaster hmSubSection ON asd.HierarchyNodeId = hmSubSection.Id
	AND hmSubSection.IsActive = 1
INNER JOIN dbo.HierarchyMaster hmSection ON hmSubSection.ParentId = hmSection.Id
	AND hmSection.IsActive = 1
--WHERE asd.AuditTypeId = 1
ORDER BY asd.AuditTypeId