• [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