SQL Server 树形表非循环递归查询
--通过子节点查询父节点WITH TREE AS(SELECT * FROM tstructure
WHERE id = 6-- 要查询的子 id
UNION ALL
SELECT tstructure.* FROM tstructure, TREE
WHERE TREE.parent = tstructure.id
)
SELECT * FROM TREE--通过父节点查询子节点WITH TREE AS(
SELECT * FROM tstructure
WHERE parent = 2-- 要查询的父 id
UNION ALL
SELECT tstructure.* FROM tstructure, TREE
WHERE tstructure.parent = TREE.id
)
SELECT * FROM TREE
页:
[1]