1 ;with cte as 2 (3 select * from Associator where No = mc10074 union all5 select air.* from Associator as air inner join cte on air ...
1 ;with cte as 2 (3 select * from Associator where No = 'mc1007'4 union all5 select air.* from Associator as air inner join cte on air.ParentNo = cte.No6 )7 select * from cte;
原标题:SQL Server 查询树结构的表,查询一个节点的所有子节点
关键词:sql
*特别声明:以上内容来自于网络收集,著作权属原作者所有,如有侵权,请联系我们:
admin#shaoqun.com
(#换成@)。