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