17,377
社区成员
发帖
与我相关
我的任务
分享
insert into tmp20171110_empjoinrec
values
((s_pfm_recid.nextval),
(select t.employee_id
from tmp20171110_empbaseinfo t, tmp20171110_12725958_01 t2
where t2.code = t.employee_code),
(select t.employee_name
from tmp20171110_empbaseinfo t, tmp20171110_12725958_01 t2
where t2.code = t.employee_code),
(select t2.joindate
from tmp20171110_empbaseinfo t, tmp20171110_12725958_01 t2
where t2.code = t.employee_code),
(select t.dept_one
from tmp20171110_empbaseinfo t, tmp20171110_12725958_01 t2
where t2.code = t.employee_code),
(select t.identity_code
from tmp20171110_empbaseinfo t, tmp20171110_12725958_01 t2
where t2.code = t.employee_code),
null);
insert into tmp20171110_empjoinrec
select s_pfm_recid.nextval,
t.employee_id,
t.employee_name,
t2.joindate,
t.dept_one,
t.identity_code,
null
from tmp20171110_empbaseinfo t, tmp20171110_12725958_01 t2
where t2.code = t.employee_code;