SELECT
a.grade_id
, a.menu_no
, nvl(a.menu_nm, c.menu_nm) menu_nm
, a.p_menu_no , b.menu_nm p_menu_nm
, a.menu_id
, a.lvl
, a.group_fg
, a.auth_s
, a.auth_i
, a.auth_u
, a.auth_d
, a.m_img_up_url
, a.m_img_down_url
, a.s_img_up_url
, a.s_img_down_url
, a.menu_order
FROM
(SELECT grade_id
, menu_no
, menu_nm
, p_menu_no
, menu_id
, level lvl
, group_fg
, auth_s
, auth_i
, auth_u
, auth_d
, m_img_up_url
, m_img_down_url
, s_img_up_url
, s_img_down_url
, menu_order
FROM
(SELECT *
FROM ft_menu_grade
WHERE grade_id = '1')
START WITH p_menu_no = '0'
CONNECT BY PRIOR menu_no = p_menu_no) a,
ft_menu_grade b,
ft_menu c
WHERE c.menu_id = a.menu_id
AND b.grade_id = a.grade_id
AND b.menu_no = a.p_menu_no
ORDER BY a.grade_id, a.menu_order
Posted by DevLima
트랙백 주소 :: http://devlima.tistory.com/trackback/41