56,677
社区成员
发帖
与我相关
我的任务
分享
insert into leave (orgid,parentid,staffname)
select tb_oa_staff.orgid,tb_oa_organization.parentid,tb_oa_staff.staffname
from tb_oa_staff inner join tb_oa_organization using(orgid)
insert into tb(key,ca2,ca3)
select key,ca2,ca3 from ta