select * from
ychis.if_feeitemlist t,ychis.r_department a,ychis.r_employee b,ychis.undrug_zt c
where t.dept_code = a.dept_code
and t.doct_code = b.empl_code
and t.zt_code = c.zt_code
select * from
ychis.if_feeitemlist t,ychis.r_department a,ychis.r_employee b,ychis.undrug_zt c
where t.dept_code = a.dept_code
and t.doct_code= b.empl_code(+)
and t.zt_code = c.zt_code