orders.sql

-- pedidos com ao menos um item sem onda.
select o.id, oi.*
  from orders o
  join orderitems oi
    on o.id = oi.OrderId
 where o.WaveId is not null
   and oi.WaveItemId is null
 order by o.id