[font="Verdana"]If I am not wrong, do you want something like this ...?
SELECT ProductId
,ProductDescription
,Sum(Quantity)
,Sum(QuantityOutstanding)
,StandardPrice
FROM Products INNER JOIN dbo.Inventory
ON dbo.Inventory.Product = dbo.Products.Product
WHERE QuantityOutstanding >0
GROUP BYProductId
,ProductDescription
,StandardPrice
I think you must not in need of stock count but Total stock. Can you spread some more light on this with desired o/p so that we can give you better solution.
Mahesh
[/font]
MH-09-AM-8694