****************************************************************************************************
Location : Local or Network Folders
Host     : FINDITEZ-T460P
Path     : C:\Users\ken\Documents\Test Cases\SSRS\Running Totals Group.rpt
****************************************************************************************************

-------------------------------------------------- Main Body --------------------------------------------------


SELECT 
	Customer.[Customer ID]
	,Customer.[Customer Name]
	,Orders.[Order Amount]
	,Orders.[Customer ID]
	,Orders.Shipped
	,Orders.[Order Amount]
FROM
	Customer
		INNER JOIN Orders ON Customer.[Customer ID] = Orders.[Customer ID]
ORDER BY
	Customer.[Customer Name] ASC -- Group #1
	,Orders.Shipped ASC