我会用 group by 以及 having :

select om.order_id
from order_mapping om left join
     temp_order_table tot
     on om.temp_order_id = tot.temp_order_id
group by om.order_id
having count(tot.temp_order_id) = count(tot.res_id);

你可以用一个不在为空的顺序

select oa.order_id 
  from order_audit oa
  where oa.order_id NOT IN (

        select om.order_id 
        from order_mapping om
        inner join (
        select to.temp_order_id 
        from temp_order_table to 
        where to.res_id is null 
        ) t on t.temp_order_id = om.temp_order_id
  )

您可以自然地联接所有其他2个表，并检查res\u id是否为null。

select oa.id, oa.order_id from order_audit oa
  where not exists (
    select * from order_mapping om
    join temp_order_table tot on
    tot.temp_order_id = om.temp_order_id
    where om.order_id = oa.order_id and tot.res_id is null
  )

这里是sqlfiddle链接的链接