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
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