9 Replies Latest reply on Aug 24, 2007 10:24 AM by suchil00

    Can't get a GROUP BY to work - what am I doing wrong?

    suchil00 Level 1
      I have a table ORDER_HEADER with the following columns - ORDER_NUMBER, ORDER_DATE and ORDER_TOTAL.
      I want a report of the order_totals by each day. I have hard coded a sample time period for testing

      I have attached the code and for the life of me I can't get it to group. The output returns all the orders with their order total.