表1
create table table1
(
id int not null,
name varchar(50)
)
create table table2
(
id int not null,
name varchar(50)
)
insert into table1
select id,name from table1
where not exists(select 1 from table2 where table1.id = table2.id)
内容全部来源于网络收集，如有侵权，请联系网站删除：QQ：24596024