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

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


SELECT 
	Customer.[Customer ID]
	,Customer.[Customer Name]
	,Customer.Country
	,Orders.[Order ID]
	,Orders.[Customer ID]
	,Orders.[Order Date]
	,Orders.[Ship Date]
FROM
	Customer
		INNER JOIN Orders ON Customer.[Customer ID] = Orders.[Customer ID]
WHERE
	Customer.Country = "Canada" 

ORDER BY
	Customer.[Customer Name] ASC -- Group #1
	,Orders.[Order Date] ASC