mysql搜索一张表数据不在另一张中

select sales_flat_order.entity_id
from sales_flat_order
where not exists (
select 1
from download_tracknumber
where download_tracknumber.id = sales_flat_order.entity_id
)

原文地址:https://www.cnblogs.com/you-jia/p/4745354.html