A表
AreaMedian,LocationMedian,Name
001 1000 2
001 1001 2B表
AreaMedian,LocationMedian
001 1000结果为
001 1001
查询A表中没有B表中的数据B表中存在的数据不显示?
AreaMedian,LocationMedian,Name
001 1000 2
001 1001 2B表
AreaMedian,LocationMedian
001 1000结果为
001 1001
查询A表中没有B表中的数据B表中存在的数据不显示?
except
select AreaMedian,LocationMedian from B
left join t_B t2
on t1.AreaMedian = t2.AreaMedian
where t1.LocationMedian <> t2.LocationMedian
MINUS
SELECT AreaMedian,LocationMedian FROM B显示A中有B种没有的数据
(select 1 from B where A.AreaMedian=B.AreaMedian and A.LocationMedian=B.LocationMedian)