如何找出两表中相同字段中不重复的记录?

图说话：

两种解答方式：

Select * from number_a
go
Select * from Number_b

go

select  Number_a.ID,Number_a.Number
from Number_a
left join Number_b on Number_b.Number=Number_a.Number
where Number_b.Number is null

go

select  Number_a.ID,Number_a.Number
from Number_a
where Number_a.Number not in (select Number_b.Number from Number_b)