2019独角兽企业重金招聘Python工程师标准>>> select a.* from table_a a left join table_b b on a.字段 = b.字段 where b.字段 is null; 转载于:https://my.oschina.net/chendongj/blog/2049899