1,593
社区成员
发帖
与我相关
我的任务
分享
select
a0.caption,a1.caption,...a[n-1].caption,a[n].caption
from
mytable as a0 /*顶级*/
left join mytable as a1 /*二级*/
on a0.id=a1.did and a1.id<>a1.did
...
left join mytable as a[n] /*第N级,N是有限制*/
on a[n-1].id=a[n].did and a[n].id<>a[n].did
where a0.id=a0.did