SQL 迭代查询语句
时间：2021-07-01 10:21:17
帮助过：89人阅读
ORG_Tree(ObjectId,parentID)
as
(
select a.ObjectId,a.parentID
from Ot_Organizationunit a
where Name
in (
‘212江苏区域‘,
‘225浙江区域‘,
‘260苏州区域‘,
‘217沪苏区域‘)
Union ALL
select b.ObjectId,b.parentID
from Ot_Organizationunit b
inner join ORG_Tree T
on b.parentID
=T.ObjectID
)
select ouser.Name,ouser.code
from OT_User ouser
inner join ORG_Tree ot
on ouser.parentid
=ot.ObjectID
SQL 迭代查询语句
标签：ati nbsp from span parent sele pl/sql use sel
