How to rewrite subquery to return only 1 row
Change your subquery select to count(*) e.g.

select o.OrderID, o.OrderAmount
from Orders o
where (select count(id) from Disputes d where d.CustomerID = o.CustomerID) &lt;= 0