---表结构：表ProductCategories，类目 idProductCategoryID，类目名称CategoryName，类目父类目 ParentCategoryID，类目级别level
---条件：不存在这样的一级和二级类目：没有子类目
select
(select pc1.ProductCategoryID from productcategories pc1 where pc1.ProductCategoryID = SUBSTRING(pc .ParentCategoryID, 1,3 )
)as ProductCategoryID
,(select pc1.CategoryName from productcategories pc1 where pc1.ProductCategoryID = SUBSTRING(pc .ParentCategoryID, 1,3 )
)as CategoryName
,(select pc1.ProductCategoryID from productcategories pc1 where pc1.ProductCategoryID = SUBSTRING(pc .ParentCategoryID, 1,6 )
)as ProductCategoryID2
,(select pc1.CategoryName from productcategories pc1 where pc1.ProductCategoryID = SUBSTRING(pc .ParentCategoryID, 1,6 )
)as CategoryName2
,pc. ProductCategoryID,pc .CategoryName
from ProductCategories pc( nolock)
where pc .Level = 3
加载中，请稍候......
加载中…
喜欢