建试图代码.txt

1.员工添加 2.人事调动 3.在职人员管理 4.部门（分厂）管理

create or replace view empsys as
select e.EMP_ID emp_id,dep_id,zhicheng_name, zhiwu_name,EMP_NAME, EMP_SEX , EMP_BIRTH , EMP_JIANLI,EMP_SHENFEN,e.states_id states_id,
 EMP_BAOZHANG, EMP_TUIZI, EMP_TUISHI, XUE_NAME, DEP_NAME, STATES_NAME, NATION_NAME from employees e,xuelis x ,departments d,states s,nations n,
 emp_zhich ez,zhichengs zch,emp_zhiwu ezh,zhiwus zw
 where e.xue_xue_id = x.xue_id and e.dep_dep_id=d.dep_id and e.states_id=s.states_id and e.nat_nation_id=n.nation_id and e.emp_id=ez.emp_id and ez.zhicheng_id=zch.zhicheng_id and ezh.emp_id =e.emp_id and ezh.zhiwu_id=zw.zhiwu_id