SQL 查询两个字段相同表的不同记录

select b.NativeName from sanleiDB.dbo.Dictionary_Native b where not EXISTS (select a.NativeName from Dictionary_Native a where a.NativeName = b.NativeName)
union
select a.NativeName from Dictionary_Native a where not exists (select b.NativeName from sanleiDB.dbo.Dictionary_Native b where a.NativeName = b.NativeName)

上一篇:SQl查询数据库库名,表名、表的列名


下一篇:不就是抽个血吗,至于么-jQuery,Linux完结篇