查找A表NAME在B表中不存在的SELECT A.NAME FROM A LEFT JOIN B ON A.NAME=B.NAME WHERE B.NAME IS NULL
select count(1) from a where not exists(select 1 from b where name = a.name)如果结果 =0 就都存在 否则反之
select name from a where name not in (select name from b) 如果有数据,就标志不存在.
declare @li_a,@li_b Select @li_a=Count(name) From 表b Where name In(Select name From 表A) select @li_b=Count(name ) From 表b IF @li_a = @li_b 全部 Else 不全 Select name From 表b Where name In(Select name From 表A) -- a和b共有的 Select name From 表b Where name NotIn(Select name From 表A) -- b有a没有 Select name From 表a Where name In(Select name From 表b) -- a有b没有
WHERE B.NAME IS NULL
否则反之
如果有数据,就标志不存在.
Select @li_a=Count(name) From 表b Where name In(Select name From 表A)
select @li_b=Count(name ) From 表b
IF @li_a = @li_b 全部
Else 不全
Select name From 表b Where name In(Select name From 表A) -- a和b共有的
Select name From 表b Where name NotIn(Select name From 表A) -- b有a没有
Select name From 表a Where name In(Select name From 表b) -- a有b没有