usid 用户名,susid:所属主用户
表: 查询结果:
usid susid usid susid usid susid
aaa aaa bbb aaa
bbb aaa aaa bbb2 aaa
bbb2 aaa bbb aaa ccc bbb
ccc bbb ccc ddd ddd ccc
ddd ccc
表: 查询结果:
usid susid usid susid usid susid
aaa aaa bbb aaa
bbb aaa aaa bbb2 aaa
bbb2 aaa bbb aaa ccc bbb
ccc bbb ccc ddd ddd ccc
ddd ccc
from ttt a, ttt b
where b.susid = a.usid;
select t1.usid,t1.susid,t2.usid,t2.susid from ttt t1,ttt t2 where t1.usid=t2.susid;
ccc ddd ddd ccc
表: 查询结果:
usid susid usid susid usid susid
aaa aaa bbb aaa
bbb aaa aaa bbb2 aaa
bbb2 aaa aaa ccc bbb
ccc bbb aaa ddd ccc
ddd ccc
select usid aaa, t.* from table t connect by prior usid=susid start with usid=aaa
父 id 孙子id
父id 曾孙子id
父id 。