USE Northwind go select employeeid ,reportsto from employees; -- 察看2的子节点,右边是左边的父节点 with myT as ( select employeeid ,reportsto from employees),myT2 as ( select * from myT where reportsto = 2 union all select myT. * from myT2 inner join myT on myT2.employeeid = myT.reportsto) select * from myT2 -- 解除递归100次的限制 option (maxrecursion 0 )