摘要： http://www.dusystem.com/bbs/ShowPost.asp?ThreadID=5631 答案 with CET as ( select C1,C2,1 as l1,2 as [l2] from a where c1='A' union all select a.*,l1+1,l2+1 from CET inner join a on CET.c2=a.c1) select *... 阅读全文