您可以执行：

insert into table1 (id, name)
select
  row_number() over(order by name) + (select max(id) from table1),
  name
from (
  select distinct name as name
  from table2 x
  where not exists (
    select name from table1 y where y.name = x.name
  )
) x;

结果：

ID   NAME  
 ---- ----- 
 348  Mike  
 349  John  
 350  Bond  
 351  Conny 
 352  Fred

请参阅db<>fiddle上的运行示例。