看图说话:
两种解答方式:
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)