안녕하세요....

test라는 테이블이 다음과 같은 결과를
---------------------------------------------
GROUP      NAME          HOST          SID 
---------------------------------------------
group1     oracle_1       59.180.2.27     ORA 
group1     oracle_2       59.180.2.26     ORA
group2     oracle_3       59.180.2.21     ORAAAA

 
이렇게 보여주고 싶은데
-----------------------------------------------------------------------------------
GROUP      NAME_1          HOST_1          SID_1       NAME_2          HOST_2        SID_2
------------------------------------------------------------------------------------
group1       oracle_1          59.180.2.27       ORA        oracle_2          59.180.2.26     ORA
group2       oracle_3          59.180.2.21       ORAAAA


union all 을 써야 할듯 한데....
잘 안되네요....