1,617
社区成员
发帖
与我相关
我的任务
分享
insert into HRS100T0_TEST(
idno ,emplno_new , emplnm ,enterdt ,eaddr ,deptno
, deptnm ,kindid , ins_user , insdate
)
select c.factno ,a.idno , a.emplno_new ,a.emplnm ,a.enterdt ,a.eaddr , c.deptno
, c.deptnm , b.kindid , a.ins_user , a.ins_date
FROM hrs100t0 a, hrs110t0 b, hrs006t0 c
where a.idno = b.idno
and b.deptid = c.deptid
and b.gradseq = 1 --当前部门职位信息
and b.stop_date is null --在职人员