I have this very complex database, from which I'm trying to figure out which orders in status 'backorder' or complete and should be shipped.
To get those ordernumbers that I search for, the following is (as simple as possible to me) what I need:
for every ordernumber in orders
where orders.status = 'backorder'
order_rows.aantal < 0 and order_rows.returned = 'YES'
and
order_rows.aantal > 0 and stock.location in 'Backorder', 'Sent'
I hope this makes it possible to start with answering my questing.
The screenshot is available both as xlsx or as pbix file. Just don't know how to upload in this question.
