為什么沒(méi)查詢出子級(jí)呢？
哪里寫(xiě)錯(cuò)了？
?
with cte as
(
select menuId, ParentID, menuName FROM voion_Menu
where ParentID=-1
union all
select d.menuId, d.ParentID, d.menuName from cte c inner join voion_Menu d
on c.ParentID = d.menuId
)
select * from cte
添加回答
舉報(bào)
0/150
提交
取消