通过SQL查询创建面包屑结构

我使用以下查询解决了SQL面包屑的上述问题

SELECt     c.Name + ' >> ' + b.Name + '>>' + a.Name AS breadcrumbFROM         tblOrganisation AS a LEFT OUTER JOINtblSubGroup AS sg ON a.SubGroupID = sg.SubGroupID LEFT OUTER JOINtblOrganisation AS b ON sg.RAOID = b.RAOID LEFT OUTER JOINtblRAO AS rao ON rao.RAOID = b.RAOID LEFT OUTER JOINtblOrganisation AS c ON c.RAOGID = rao.RAOGIDWHERe     (sg.RAOID IS NOT NULL) AND (a.OrgID = @ORGID)UNIOnSELECt     c.Name + ' >> ' + a.Name AS breadcrumbFROM         tblOrganisation AS a LEFT OUTER JOINtblRAO AS rao ON rao.RAOID = a.RAOID LEFT OUTER JOINtblOrganisation AS c ON c.RAOGID = rao.RAOGIDWHERe     (rao.RAOID IS NOT NULL) AND (a.OrgID = @ORGID)UNIOnSELECt     Name AS breadcrumbFROM         tblOrganisation AS aWHERe     (RAOGID IS NOT NULL) AND (OrgID = @ORGID)