sunyn713

多思考,勤总结

导航

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)

posted on 2015-04-16 15:34  sunyn713  阅读(675)  评论(0)    收藏  举报