SQL 迭代查询语句
标签：ati nbsp from span parent sele pl/sql use sel
SQL 迭代查询语句
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