我使用以下查询解决了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)
