left join 数据为什么没有显示,分页
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
补充:.NET技术 , ASP.NET