I have a database that has orders (inventory going out) and purchases (inventory coming in). I need a query to comine the two to easily view present inventory.
There is a stockpile table that lists all the products and what how many we should keep in stock.
There is a purchase details query that shows what was purchased (this is actual inventory in stock.)
There is a order details query that shows what was sold (distributed from stockpile).
I need a query that will show what is in inventory for every item (sum purchase details) less order details query (what was sold). Then I need to compare it to the required stockpile to see if we are over/under.
By example Query should function: Need to purchase
Product Stockpile Purchase total Sales(orders) Difference Stockpile - Diff
White mug 10 20 11 9 1
Blue mug 40 40 4 36 4
By example Query should show:
Product Stockpile On hand Order
White mug 10 9 1
Blue mug 40 36 4
Work with freelancers specializing in everything from database administration to programming, who have proven themselves as experts in their field. Hire the best, collaborate easily, pay securely, and get projects done right.