USE RJSite
GO
WITH temp
AS ( SELECT *
FROM dbo.VideoType
WHERE ID = 1 --要查询的子类ID
UNION ALL
SELECT v.*
FROM VideoType AS v ,
temp
WHERE v.PID = temp.ID -- 查询所有子类
)
SELECT *
FROM temp;
WITH temp2
AS ( SELECT *
FROM dbo.VideoType
WHERE ID = 9 --要查询的子类ID
UNION ALL
SELECT v.*
FROM VideoType AS v ,
temp2
WHERE v.ID = temp2.PID -- 查询所有父类
)
SELECT *
FROM temp2