我有两个表(订单,订单项),它们基于一个名为OrderID的列相关联。我需要找到所有没有任何订单项的订单。
我有两个表(订单,订单项),它们基于一个名为OrderID的列相关联。我需要找到所有没有任何订单项的订单。
WHERE id NOT IN (...)
的查询更有效率。select *
from
Orders O
left outer join OrderItems I
on I.OrderId = O.Id
where
I.Id is null
Select * From Orders Where OrderID not in (Select Distinct OrderID From OrderItems)
尝试使用LEFT EXCEPTION JOIN
select *
from Orders
LEFT EXCEPTION JOIN OrderItems ON ...