no, not really... sum is part of the query:
count(if(a.Type = "SBR", a.amount,'')), sum(a.amount) .... group by..
i want this:
go through the records.....
count only the ones the have type = "SBR"
sum all amounts....
etc...
etc...
group by date with rollup
i.e. i'd like to (assuming in the above example that _type_ and
_amount_ are column names) sum all the amounts but count only the ones
with a certain type, all other amounts that are different type should
not be part of the count, but still should be summed..
how can i do that?!
thanks....
Perrin Harkins wrote:
On Tue, Sep 23, 2008 at 9:29 PM, kalin m <[EMAIL PROTECTED]> wrote:
count(if(a.Type = "Signature Based Return", a.amount,'')).... group by....
order by....
I think you're looking for sum().
- Perrin
