Re: [SQL] Aggregate versus lineitem report

2005-10-29 Thread Bruno Wolff III
On Fri, Oct 21, 2005 at 11:32:13 -0400, Jerry Blumenthal <[EMAIL PROTECTED]> wrote: > How do you get a report that lists items and then produces a sum at the > end. Like this: > > name date amount1 amount2 > name date amount1 amount2 > name date amount1 amount2 > > tot

[SQL] Aggregate versus lineitem report

2005-10-24 Thread Jerry Blumenthal
How do you get a report that lists items and then produces a sum at the end. Like this: name date amount1 amount2 name date amount1 amount2 name date amount1 amount2 totals sum(amount1) sum(amount2) The sql command I am using now is SELECT SUM(Tcode.T_a