Question

查询两个相同表中不同记录，这样的SQL语句怎么写

Answer 1

select t1.a,t1.b from t1 aa,t2 bb
where aa.a=bb.a
and aa.b not in (select cc.b from t2 cc where aa.a=cc.a);
试试看，行不行