----建表
create table table1(code nvarchar(3),name nvarchar(10))
create table table2(code nvarchar(3),other nvarchar(10))
--生成测试数据
insert into table1 values ('100','ss')
insert into table1 values ('101','aa')
insert into table1 values ('345','bb')
insert into table1 values ('653','dd')
insert into table2 values ('100','mmsdf')
insert into table2 values ('101','asfsf')
insert into table2 values ('345','asf')
insert into table2 values ('123','afsaf')--测试代码
select *
from table2
where code not in(
select code
from table1
) --运行结果
code other
123 afsaf
create table table1(code nvarchar(3),name nvarchar(10))
create table table2(code nvarchar(3),other nvarchar(10))
--生成测试数据
insert into table1 values ('100','ss')
insert into table1 values ('101','aa')
insert into table1 values ('345','bb')
insert into table1 values ('653','dd')
insert into table2 values ('100','mmsdf')
insert into table2 values ('101','asfsf')
insert into table2 values ('345','asf')
insert into table2 values ('123','afsaf')--测试代码
select *
from table2
where code not in(
select code
from table1
) --运行结果
code other
123 afsaf
select *
from table2 a
where not exists (
select *
from table1 b
where a.code=b.code
)