896번 참조 하심 될것같네요

896번 게시물을 찾아봤는데...무슨 한글깨짐 관련 물음이던데요...

번호를 잘못 말씀해주신것 같아요..

다시 한번 알려주세요 ^^

이렇게 테스트 해봤네요.

create table menu
(
menu_id char(10) null,
parent_menu_id char(10) null,
menu_name char(20) null
)

insert into menu values ('menu1',null,'1단메뉴-1')
insert into menu values ('menu2',null,'1단메뉴-2')
insert into menu values ('menu11','menu1','2단메뉴-11')
insert into menu values ('menu12','menu1','2단메뉴-12')
insert into menu values ('menu21','menu2','2단메뉴-21')
insert into menu values ('menu111','menu11','3단메뉴-111')

select * from menu

select
 a.menu_name as "1단메뉴",
 b.menu_name as "2단메뉴",
 c.menu_name as "3단메뉴"
from menu a left outer join menu b
on (a.menu_id = b.parent_menu_id)
left outer join menu c
on (b.menu_id = c.parent_menu_id)
where  a.menu_id like 'menu[1-9]'
and b.menu_id like 'menu[1-9][1-9]'

결과

1단메뉴            2단메뉴            3단메뉴

===========================================

1단메뉴-1         2단메뉴-11        3단메뉴-111     
1단메뉴-1         2단메뉴-12        
1단메뉴-2         2단메뉴-21        

결과가 원하는 거와 같은지 모르겠네요.