怎么检索这样的数据

[另一花生]

看到特点了么？fid是上一级部门的，添加部门时候也必须指名上级部门，谢谢高手指点啊

[叶涛网站推广优化]

select * from TABLE start with fid = 0 connect by prior id = fid;

[另一花生]

引用 1 楼 yetaodiao 的回复:

select * from TABLE start with fid = 0 connect by prior id = fid;

出错了

[另一花生]

select c.* from (表名) as c,(表名) as p where c.dept_fid = p.dept_id