[thelist] Creating Reports: Where to put the logic?

[Matthew Bernhardt]

Hey Casey,
   Try something along these lines:

SELECT salesRep, Sum(salesAmount) AS salesTotal
 FROM sales
GROUP BY salesRep

What db are you using? SQL server? MySQL? Oracle?

Matt

On Wed, 21 Jun 2006 12:31:32 -0400, Casey Crookston  
<caseyc at IntelliSoftmn.com> wrote:

> Ok, I'm creating a report which totals up sales by sales reps.  To
> simplify, we've got a query that looks like this (not really but for my
> learning purposes this will do):
>
>
> SELECT salesRep, salesAmount FROM sales
>
>
> And returns this:
>
>
> Billy Bob           45.00
>
> Billy Bob           50.00
>
> Sally Jane         79.00
>
> Sally Jane         32.00
>
> Billy Bob             5.00
>
> Sally Jane         20.00
>
> Sally Jane         10.00
>
>
> I need the report to look like this:
>
>
> Billy Bob           100.00
>
> Sally Jane         141.00
>
>
> I would really prefer to do the logic in the query, if that's possible.
> I've been looking at the sum(column) function, but can't quit get it
> working.  Is it possible, and if so, what would the query look like?
>
>
> Thanks!
>
>
> Casey
>



-- 
Matt Bernhardt, bernhardt.7 at osu.edu
Webmaster  +  Fab  Lab  Coordinator
Knowlton  School   of  Architecture
The    Ohio     State    University