SQL> select * from tree;BH MC SJBH
---------- -------------------- ----------
1 china
2 ShangHai 1
3 ShangHai-1 2
4 BeiJin 1
5 ShangHai-2 2SQL> select * from tree
2 start with bh='2'
3 connect by prior bh=sjbh;BH MC SJBH
---------- -------------------- ----------
2 ShangHai 1
3 ShangHai-1 2
5 ShangHai-2 2
---------- -------------------- ----------
1 china
2 ShangHai 1
3 ShangHai-1 2
4 BeiJin 1
5 ShangHai-2 2SQL> select * from tree
2 start with bh='2'
3 connect by prior bh=sjbh;BH MC SJBH
---------- -------------------- ----------
2 ShangHai 1
3 ShangHai-1 2
5 ShangHai-2 2
start with organID='123'
connect by prior organID=upOrganID;
select * from tables where upOrganID ='123';行吗?
你的SQL只能查询出123的直属的下属机构,这些下属机构的下属机构就查不出来了,肯定要用connect by的!