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

时间:2023-03-09 07:25:33
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)