概述with tmp as( SELECT * FROM TBasDepartment WHERE DepartmentID=511 union all SELECT a.* FROM TBasDepartment a,tmp b WHERE a.PDepartmentID = b.DepartmentID ) SELECT * FROM tmp with tmp as( SELECT * FROM TBasDepartment WHERE DepartmentID=511 union all SELECT a.* FROM TBasDepartment a,tmp b WHERE a.PDepartmentID = b.DepartmentID ) SELECT * FROM tmp 总结
评论列表(0条)