比如表dbo.DangAn表中有的而dbo.YongHu表没有的值都显示出来
SELECT * FROM dbo.DangAn a WHERE a.xCode NOT IN( SELECT b.yCode FROM dbo.YongHu b)
表dbo.YongHu有的字段,而在表dbo.DangAn是没有的值都显示出来
SELECT * FROM dbo.YongHu a WHERE a.yCode NOT IN(SELECT b.xCode FROM dbo.DangAn b )
比如表dbo.DangAn表中有的而dbo.YongHu表没有的值都显示出来
SELECT * FROM dbo.DangAn a WHERE a.xCode NOT IN( SELECT b.yCode FROM dbo.YongHu b)
表dbo.YongHu有的字段,而在表dbo.DangAn是没有的值都显示出来
SELECT * FROM dbo.YongHu a WHERE a.yCode NOT IN(SELECT b.xCode FROM dbo.DangAn b )