Question

SQL not in 两个表找不同的问题 100分在线等……

Answer 1

select * from t1 where a1 not in (select a1 from t2)

或者

select * from t1 where not exists(select t2.a1 from t2 where t2.a1=t1.a1)

建议用not exists,比in快