Find records that do not have related records in SQL

I have 2 tables (Orders, Orde开发者_StackOverflow中文版rItems) that are related based on a column OrderID. I need to find all Orders that do not have any OrderItems.

---

We use JOIN to find related data. To find data without any related data, we can use an anti-join.

The following joins the tables, then selects those without any order items. This tends to be more efficient that a WHERE id NOT IN (...) style query.

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)

---

try with LEFT EXCEPTION JOIN

select *
from Orders
LEFT EXCEPTION JOIN OrderItems ON ...