음 이쿼리를 어디다 쓸지는 모르겠지만 뭔가 잘못된 쿼리인듯 합니다..... 일단 데이터 타입이 다르구요... 다 스트링인건지...

일단 억지로라도 한 번 만들어 봤습니다.... 도움이 되실지는;;; 아니면 다음 고수분께 패스....

drop table test1;

drop table test2;

create table test1

(

idx int,

val1 nvarchar(10),

val2 nvarchar(10)

)

insert into test1 values (1, '가', 150), (2, '나', 160), (3, '다', 180);

create table test2

(

idx int,

val nvarchar(10)

)

insert into test2 

values (1, 'A')

, (1, 'B')

, (1, 'C')

, (2, 'A1')

, (2, 'B1')

, (2, 'C1')

, (3, 'A2')

, (3, 'B2')

, (3, 'C3');

select max(cast(co1 as nvarchar)) as co1

, max(cast(co2 as nvarchar)) as co2

, max(cast(co3 as nvarchar)) as co3 

from (

select ROW_NUMBER() OVER(PARTITION BY idx ORDER BY idx) as num

, case idx when 1 then idx end as co1

, case idx when 2 then idx end as co2

, case idx when 3 then idx end as co3

from test1 ) as z1

group by num

union all

select max(co1) as co1

, max(co2) as co2

, max(co3) as co3 

from (

select ROW_NUMBER() OVER(PARTITION BY idx ORDER BY idx) as num

, case idx when 1 then val1 end as co1

, case idx when 2 then val1 end as co2

, case idx when 3 then val1 end as co3

from test1 ) as z1

group by num

union all

select max(co1) as co1

, max(co2) as co2

, max(co3) as co3 

from (

select ROW_NUMBER() OVER(PARTITION BY idx ORDER BY idx) as num

, case idx when 1 then val2 end as co1

, case idx when 2 then val2 end as co2

, case idx when 3 then val2 end as co3

from test1) as z1

group by num

union all

select max(co1) as co1

, max(co2) as co2

, max(co3) as co3 

from (

select ROW_NUMBER() OVER(PARTITION BY idx ORDER BY idx) as num

, case idx when 1 then val end as co1

, case idx when 2 then val end as co2

, case idx when 3 then val end as co3

from test2) as z1

group by num