Oracle 树查询

select t.*, t1.user_name as CREATOR_NAME, t2.user_name as LAST_UPDATE_USER_NAME

from t_sys_menu t

left join t_sys_user t1 on t.creator = t1.user_name

left join t_sys_user t2 on t.last_update_user = t2.user_name

where t.display_language = 'zh-CN'

start with t.parent_id = '01' connect by t.parent_id = prior t.primary_id

and t.display_language = prior t.display_language

posted @ 2018-11-09 16:02  ☆尘世佛心☆  阅读(105)  评论(0)  编辑  收藏  举报