I'm hoping there's a real easy way of doing this that I'm just missing:
Given a Select statement such as:
Select ID, code, amount from foo where code < 10;
that gives me a table like this:
ID code amount
_____________________________________
1 4 20
2 3 10
3 4 15
4 2 10
5 3 9
6 3 8
I want to generate a report table like the following (group by code):
ID code amount
_____________________________________
4 2 10
2 10
2 3 10
5 3 9
6 3 8
3 27
1 4 20
3 4 15
4 35
72
Such that the final table has additional subtotal rows with the
aggregate sum of the amounts. I'm thinking I can generate two tables
and merge them, but is there an easier way using a fancy Select
statement?
-Owen
---------------------------(end of broadcast)---------------------------
TIP 5: don't forget to increase your free space map settings
