Find it EZ

Location: Local or Network Folders
Host: FINDITEZ-T460P
Path: C:\Users\ken\Documents\Test Cases\en\Samples\Reports\General Business\Order Packing List.rpt
Main Body
SELECT
        Customer.[Customer ID]
        ,Customer.[Customer Name]
        ,Customer.Address1
        ,Customer.Address2
        ,Customer.City
        ,Customer.Region
        ,Customer.Country
        ,Customer.[Postal Code]
        ,Employee.[Employee ID]
        ,Employee.[Last Name]
        ,Employee.[First Name]
        ,Orders.[Order ID]
        ,Orders.[Customer ID]
        ,Orders.[Employee ID]
        ,Orders.[Ship Via]
        ,Orders.Shipped
        ,Orders_Detail.[Product ID]
        ,Orders_Detail.Quantity
        ,Product.[Product ID]
        ,Product.[Product Name]
        ,Product.Color
        ,Product.Size
        ,Orders_Detail.[Unit Price] -- In unused formula
FROM
        Customer
                INNER JOIN Orders ON Customer.[Customer ID] = Orders.[Customer ID]
                INNER JOIN Employee ON Orders.[Employee ID] = Employee.[Employee ID]
                INNER JOIN [Orders Detail] Orders_Detail ON Orders.[Order ID] = Orders_Detail.[Order ID]
                INNER JOIN Product ON Orders_Detail.[Product ID] = Product.[Product ID]
WHERE
        not Orders.Shipped --Orders.[Order Date] in (Date (1998, 04, 12), Date (1998, 04, 30))
ORDER BY
        Customer.[Customer Name] ASC -- Group #1
        ,Orders.[Order ID] ASC -- Group #2