SQL Statement

[Guest]

I have two SQL statements, one is giving me the total Quantity
available(from Stock table) and the other one is giving me the total number
of Quantity sold out.(from Sales Table). All these are GROUPED BY Item Name
e.g Handbags 3

Shoes 10
Is there a way of creating another SQL statement that will subtract the
Quantity sold from the total Quantity available so that I know the STOCK
REMAINING.
I need the syntax.

 

[Lynn Trapp]

Give this a try.

SELECT StockTable.ItemName, Sum(STockTable.QtyAvailable),
Sum(SalesTable.QtySold)
FROM StockTable Join on StockTable.ItemName = SalesTable.ItemName
GROUP BY StockTable.ItemName

 

[David Seeto via AccessMonster.com]

You've got to be kidding - you've posted FOUR separate threads on the same question?!? Please please PLEASE don't do this!

*****************************************
* A copy of the whole thread can be found at:
* http://www.accessmonster.com/Uwe/Forum.aspx/access-tablesdbdesign/6298
*
* Report spam or abuse by clicking the following URL:
* http://www.accessmonster.com/Uwe/Abuse.aspx?aid=9ac660b60152480bab38bc9ffa28c889
*****************************************