ORACLE(SQL)使用小记

来源:互联网 发布:淘宝网购物女装衬衣 编辑:程序博客网 时间:2024/05/22 15:09

1获取菜单树形主从数据

select PIDCaption,Caption from (SELECT id,Caption as PIDCaption from tb_menu  where pid=-1) as a LEFT JOIN (SELECT pid,Caption from tb_menu where pid!=-1 and Caption!='-') as b on a.id=b.pid

0 0
原创粉丝点击