SELECT DISTINCT ProductCategoryID,
                Name

FROM      Production.ProductCategory

ORDER BY  Name