with tour_group as
(
    select '111' tour_key, '중국관광단' tour_title, '중국' tour_position, '2011.01.03' start_day, '2011.01.13' end_day from dual union all
    select '222', '일본광광단', '일본', '2011.01.05', '2011.01.11' from dual
),
tour_person as
(
    select '111' tour_key, 1 tour_seq, '백두산' tour_person_name from dual union all
    select '111', 2, '한라산' from dual union all
    select '111', 3, '금강산' from dual union all
    select '222', 1, '김대리' from dual union all
    select '222', 2, '박과장' from dual union all
    select '222', 3, '최과장' from dual union all
    select '222', 4, '권차장' from dual union all
    select '222', 5, '신부장' from dual
)
select a.tour_title, a.tour_position, a.start_day, a.end_day
     , wm_concat(b.tour_person_name) name
from tour_group a, tour_person b
where a.tour_key = b.tour_key
group by a.tour_title, a.tour_position, a.start_day, a.end_day