oracle 语句小计

select e.em_name,e.em_id,dm.de_name,dm.de_id,dm.de_father 
   from employee e 
   right join ( select * from department d start with d.de_id=1   
                   connect by prior d.de_id=d.de_father) dm on e.em_dename=dm.de_name where e.em_id=89
                   
select * from (select e.em_name,e.em_id,dm.de_name,dm.de_id,dm.de_father 
   from employee e 
   right join ( select * from department d start with d.de_id=1   
                   connect by prior d.de_id=d.de_father) dm on e.em_dename=dm.de_name where e.em_id=89 ) h left  join (select * from p_attendance p where 
p.year_month='2013-03') pa on h.em_id=pa.p_id


select * from (select e.em_name,e.em_id,dm.de_name,dm.de_id,dm.de_father 
   from employee e 
   right join ( select * from department d start with d.de_id=1   
                   connect by prior d.de_id=d.de_father) dm on e.em_dename=dm.de_name ) h left  join (select * from p_attendance p where 
p.year_month='2013-03') pa on h.em_id=pa.p_id