可以查出data_pool中appleid在表appleid_use_record表中不存在的数据select * from data_pool t where not exists (select 1 from appleid_use_record m where t.appleid=m.appleid)