SQLSERVER: 利用关键字exceptOracle:minus其语法与Union相同。
select * from A表 where 列名 not in (select 列名 from B表)
若列名为【colvalue】select * from a where colvalue not in(select colvalue from b)
select a.列名 from a where a.列名 not in (select b.列名 from b)
用左右连接不就行了?