Find it EZ

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