条件是不是如下对应,组织层级顺序是哪个字段顺序 select b.orgId, b.parentOrgId, b.orgOrder, a.userId, a.userOrder from user a, (select * from org connect by prior orgId = parentOrgId start with parentOrgId is null) b where a.userOrder(+) = orgOrder and a.orgid(+) = b.orgid order by b.parentOrgId NULLS FIRST, b.orgId, b.orgOrder
你把order by 去掉就是先是父组织0,再是子组织01,孙组织011,再是子组织02.....了啊
select b.orgId, b.parentOrgId, b.orgOrder, a.userId, a.userOrder
from user a,
(select *
from org
connect by prior orgId = parentOrgId
start with parentOrgId is null) b
where a.userOrder(+) = orgOrder
and a.orgid(+) = b.orgid
order by b.parentOrgId NULLS FIRST, b.orgId, b.orgOrder