行列转制的交叉表数据

select * from (  select CASE  WHEN p.p_isceo ='集团领导' THEN 1 WHEN
 p.p_isceo ='总部高管' THEN 2  WHEN p.p_isceo ='子公司高管' THEN 3 WHEN 
 p.p_isceo ='总部中层' THEN 4WHEN p.p_isceo ='子公司中层' THEN 5 WHEN 
 p.p_isceo ='总部一般成员' THEN 6WHEN p.p_isceo ='子公司一般成员' THEN 7
  END thisyearlevel ,p.p_isceo,count(p.p_isceo) as thisyearpersoncount from
   ysu_fams_taskperson p left join ysu_fams_tasks task on p.t_t_id = task.t_id
     where to_char(task.t_startdate,'yyyy') = '2010' group by p.p_isceo ) thisyear 
     left join (select CASE WHEN p.p_isceo ='集团领导' THEN 1WHEN p.p_isceo 
     ='总部高管' THEN 2 WHEN p.p_isceo ='子公司高管' THEN 3WHEN p.p_isceo =
     '总部中层' THEN 4 WHEN p.p_isceo ='子公司中层' THEN 5WHEN p.p_isceo ='
     总部一般成员' THEN 6 WHEN p.p_isceo ='子公司一般成员' THEN 7 END 
     mylevel,p.p_isceo as lp_isceo,count(p.p_isceo) as lastyearpersoncount from 
     ysu_fams_taskperson p left join ysu_fams_tasks task on p.t_t_id = task.t_id where to_char(task.t_startdate,'yyyy') = '2009' 
group by p.p_isceo order by mylevel asc ) lastyear on thisyear.thisyearlevel =
lastyear.mylevel order by thisyear.thisyearlevel