****************************************************************************************************
Location : Local or Network Folders
Host     : FINDITEZ-T460P
Path     : C:\Users\ken\Documents\Test Cases\en\Samples\Reports\General Business\Inventory CrossTab.rpt
****************************************************************************************************

-------------------------------------------------- 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