SELECT Product.[Product Class], Product.[Product Name], Product.[M/F], Product.Size, Product.Color, Product.[Product ID], Product_Type.[Product Type Name], Product.[Price (SRP)], Product_Type.Description, Product_Type.Picture
FROM Product Product INNER JOIN [Product Type] Product_Type ON Product.[Product Type ID]=Product_Type.[Product Type ID]
ORDER BY Product.[Product Class], Product_Type.[Product Type Name], Product.[Product Name], Product.[Product ID]