有点错 select a.* from a left b on a.id=b.id where b.id is null or select * from a where not exists(select top 1 1 from b where a.id=id) or select * from a where in not in(select id from b)
Select a.* from a,b where a.字段 not in (b.字段)
Select a.* from a,b where a.字段<>b.字段
select * from a where 字段 not in (select 字段 from b)
select * from a where id not in(select id from b) or select a.* from a,b where a.id<>b.id
Select a.* from a,b where a.字段<>b.字段
select a.* from a where a.id not in (select b.id from b)
select a.* from a left b on a.id=b.id
where b.id is null
or
select * from a where not exists(select top 1 1 from b where a.id=id)
or
select * from a where in not in(select id from b)
or
select a.* from a,b where a.id<>b.id