Trying to get an sql for an warehouse that shows the following.
-
We have purchase orders that have arrived to the warehouse. For example table “Inbound”, in that table we have purchase order number, article name quantity etc.
-
We want to see what purchase orders that contains articles that have zero in stock for the warehouse. The articles in the warehouse is for example table “articles”
Any tips on how I can achieve this?