Find it EZ

Location: Local or Network Folders
Host: FINDITEZ-T460P
Path: C:\Users\ken\Documents\Test Cases\en\Samples\Reports\General Business\Product Catalog.rpt
Main Body
SELECT
        Product.[Product ID]
        ,Product.[Product Name]
        ,Product.Color
        ,Product.Size
        ,Product.M/F
        ,Product.[Price (SRP)]
        ,Product.[Product Type ID]
        ,Product.[Product Class]
        ,Product_Type.[Product Type Name]
        ,Product_Type.Description
        ,Product_Type.[Graphic Image Location]
FROM
        Product
                INNER JOIN [Product Type] Product_Type ON Product.[Product Type ID] = Product_Type.[Product Type ID]
ORDER BY
        Product.[Product Class] ASC -- Group #1
        ,Product_Type.[Product Type Name] ASC -- Group #2
        ,Product.[Product Name] ASC -- Group #3
        ,Product.[Product ID] ASC