Posted on 2013-01-13
INVENTORY.partid, INVENTORY.description, (INVENTORY.reorderpnt - INVENTORY.stockqty)
Display the part id and description for all parts where the stock quantity is less than the reorder point. I have this one working:
WHERE Stockqty <= Reorderpnt;
How can I modify the query above to get the below :
For each part where this is true also display the amount that the stock quantity is below the reorder point. Display the parts in descending order of the computed difference.