Web Listing 2: SQL statement for click-through query

SELECT        Production.Product.ProductID, Production.ProductInventory.LocationID, Production.ProductInventory.Shelf, Production.ProductInventory.Bin,

                         Production.ProductInventory.Quantity, Production.Product.Name, Production.Product.ProductNumber
FROM            Production.Product INNER JOIN
                         Production.ProductInventory ON Production.Product.ProductID = Production.ProductInventory.ProductID
WHERE        (Production.Product.ProductID = @ProductIDWanted)