选择存在于tA表中,但其中name不存在于tB表中的数据
select id, name, gender, classId from tA where not exists (select name from tB where tA.name=tB.name)
not in 的写法,同样的效果,但是在大数据量的时候效率不高
select id, name, gender, classId from tA where name not in (select name from tB where tA.name=tB.name)
或者
select id, name, gender, classId from tA where name not in (select name from tB)