Sylvain

So the group by is the same as a grouping clause in a report. The only difference is that it does the grouping with the records PRIOR to the report and this, the detail of the report would be JUST the grouped records and not the individual ones that make it up.

If that is the case, if I want the detail as well as group footers with totals, I would NOT use the GROUP BY in the select but instead use a DATA GROUPING in the report to catch the totals in the header.


Correct?


>>What is the difference between ORDER BY and GROUP BY?
>
>Hi Peter,
>
>As Pete said, ORDER BY should be enough for you, but I'll give an example of GROUP BY, if you don't mind.
>
>Let's assume the following simple table, which would be the child table of an invoice:
>
>

>InvNo         Amount
>--------------------
>0001          120.00
>0002           40.00
>0001           15.00
>0001           10.00
>0002           20.00
>

>
>GROUP BY will usually be used with a function such as SUM(). For example, if what you want is the total for each invoice, SELECT InvNo, SUM(Amount) AS Total FROM InvDetail GROUP BY InvNo would return:
>
>

>InvNo      Total
>----------------
>0001      145.00
>0002       60.00
>

>
>I hope this clears things up a little!