62,025
社区成员
发帖
与我相关
我的任务
分享
select top 10 a.Name as CName,b.*
from Products b left join Categories a
on b.CategoryId=a.CategoryId
where b.Productid not in (select top 10 ProductId from Products order by b.lft,b.sort,b.ProductId)
order by b.lft,b.sort,b.ProductId