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