select 

a.manage_unit    as 区分, round(a.IHGU,4) as IHGU,  round(a.OTT,4) as OTT,  round(b.tousu_timely,4) as 投诉处理及时率, round(c.work_timely,4) as 新装投诉率,

round(d.work_rate,4)  as 安装成功率

from  

 MONTH_BOX_TIMELY A,

 TOUSU_DEL_TIMELY B,

 TOUSU_WORK_TIMELY C,

 WORK_SUCCEED_RATE D

 where  a.manage_unit=b.manage_unit  and  b.manage_unit=c.manage_unit  and  c.manage_unit=d.manage_unit

and  a.manage_unit='浦东'

不知道应该怎么在select中  将这个表给它转置，希望哪位大神可以指点一二！！！小生万分感谢

select manage_unit as IHGU, round(IHGU,4)  from  MONTH_BOX_TIMELY   where manage_unit='浦东'

union all 

select manage_unit as OTT, round(OTT,4)  from  MONTH_BOX_TIMELY   where manage_unit='浦东'

union all 

select manage_unit as 投诉处理及时率, round(tousu_timely,4)from  TOUSU_DEL_TIMELY where manage_unit='浦东'

union all 

select manage_unit as 新装投诉率, round(work_timely,4)from   TOUSU_WORK_TIMELY  where manage_unit='浦东'

union all 

select manage_unit as 安装成功率, round(work_rate,4)from   WORK_SUCCEED_RATE  where manage_unit='浦东'