22,209
社区成员
发帖
与我相关
我的任务
分享
WITH test AS
(
SELECT [单位ID] FROM 单位信息表 WHERE [单位名称]=N'永州市教育局'
UNION ALL
SELECT B.[单位ID]
FROM test AS A
JOIN 单位信息表 AS B ON A.[单位ID]=B.[上级单位ID]
)
SELECT A.*
FROM 个人信息表 AS A
JOIN test AS B ON A.单位ID =B.单位ID