用什么数据库?试试严格点的写法

insert into lib.temp
select
a.id,a.dob,b.emp,b.salary
from
employ as a inner join personel as b on a.id = b.emp