查询树形结构中产品的所有上级

amazeyeli

源表:(id:本身id,name:产品名称,eid:上级id)

id	name	eid
1	电脑
2	联想	1
3	x230	2
4	x230I	3
5	x230c	3
6	X240	2
7	X240a	6
8	X240c	6
9	冰箱
10	a	9

结果:

id	name	eid
1	电脑
2	联想	1
3	x230	1
3	x230	2
4	x230I	1
4	x230I	2
4	x230I	3
5	x230c	1
5	x230c	2
5	x230c	3
6	X240	1
6	X240	2
7	X240a	1
7	X240a	2
7	X240a	6
8	X240c	1
8	X240c	2
8	X240c	6
9	冰箱
10	a	9

代码:

1. select id,name,eid as eid from [sheet1$]
   
2. union all
   
3. select a.id,a.name,b.eid from [sheet2$] as a inner join [sheet1$] as b on a.eid=b.id
   
4. where b.eid is not null
   
5. order by 1

复制代码

动画:


附件:
AmaZeYeLi.rar (11.15 KB, 下载次数: 88)

2014-4-15 13:07 上传

点击文件名下载附件

提问:
查询树形结构中产品的所有下级

as42065300

高手出招了，呵呵收藏了！