Subject RE: [ib-support] Newbie trying to understand the GROUP BY statement. Help!
Author Tobias Giesen

I have to correct the last part of what I wrote here:
> If you don't want to use a reporting tool, use two
> separate queries.

Obviously, I should have said: use only one query for the
ordered and grouped data and calculate the sums yourself
in the client software. Which is what reporting tools do.