SELECT  ProductSubcategoryID, 
        ProductCategoryID, 
        Name

FROM    Production.ProductSubcategory

WHERE   ProductCategoryID = @ProductCategory