兩個資料表對應出差異資料

select resak001 from resak where resak001 not in(select MV001 FROM [172.16.200.81].Leader.dbo.CMSMV group by MV001)
select MV001 as 員工代號,MV002 as 姓名,MV003 as 申報公司別,MV004 as 部門別,MV005 as 職等,MV006 as 職務, MV007 as 性別, MV020 as EMail FROM [172.16.200.81].Leader.dbo.CMSMV where MV002='趙爾婉'

select MV001,MV002  from [172.16.200.81].Leader.dbo.CMSMV where MV001 >'1949'

insert
select * from efste

原文轉自：http://www.kjueaiud.com