日志类别：数据库
2013-12-05 18:21
请自行理解，关键步骤是with tree 和 inner join tree...
WITH TREE as
(
SELECT *
FROM [GROUP]
WHERE GROUP_ID = 1
UNION ALL
SELECT MENU.*
FROM [GROUP]
AS MENU
INNER JOIN TREE
AS CHILD
ON MENU.PARENT_GROUP_ID = CHILD.GROUP_ID
)
select *
from TREE