Skip to content

Instantly share code, notes, and snippets.

@diegodfsd

diegodfsd/orders.sql

Created July 23, 2019 20:49
Show Gist options
  • Save diegodfsd/a3e262bb5a9c54ad5111e68350b5cbc4 to your computer and use it in GitHub Desktop.
Save diegodfsd/a3e262bb5a9c54ad5111e68350b5cbc4 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
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
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment