[SQL-码农]跟大批量的IN 与 NOT IN 分手吧

T_a

ID	Content
1	----
2	----
3	----
4	----

T_b

ID	Content
1	----
2	----

 

--IN的用法--
select a.* 
	from T_a a
	join T_b b on a.ID=b.ID
	where 1=1

--NOT IN的用法--
select a.* 
	from T_a a
	left outer join T_b b on a.ID=b.ID
	where 1=1
	and b.ID is null