Main Body
SELECT
Product.[Product ID]
,Product.[Product Name]
,Product.[Product Type ID]
,Product.[Product Class]
,Product.[Supplier ID]
,Product_Type.[Product Type Name]
,Product_Type.Picture
,Purchases.[Product ID]
,Purchases.[Units in Stock] -- In unused formula
,Purchases.[Units on Order]
,Purchases.Received
,Product.Color -- In unused formula
,Product.Size -- In unused formula
,Product.M/F -- In unused formula
,Purchases.[Reorder Level] -- In unused formula
FROM
Product
INNER JOIN [Product Type] Product_Type ON Product.[Product Type ID] = Product_Type.[Product Type ID]
INNER JOIN Purchases ON Product.[Product ID] = Purchases.[Product ID]
WHERE
Product.[Product Class] = "Accessory" and
not (Product.[Product Name] startswith "Xtreme")
ORDER BY
Product_Type.[Product Type Name] ASC -- Group #1