[thelist] What's wrong with my query?
Matt Warden
mwarden at gmail.com
Thu May 17 15:02:23 CDT 2007
On 5/17/07, Casey Crookston <caseyc at intellisoftmn.com> wrote:
> ID Business_Name Points Awarded
>
> ----------------------------------------------------------
>
> 1 tom and jerry 15
>
> 2 tom and jerry 75
>
> 3 tom and jerry 20
>
> 4 abbott and costello 5
>
> 5 abbott and costello 90
>
>
>
> I'd like to return this result:
>
>
>
> tom and jerry 110
>
> abbot and costello 95
select Business_Name, sum([Points Awarded])
from tablename
group by Business_Name
--
Matt Warden
Cleveland, OH, USA
http://mattwarden.com
This email proudly and graciously contributes to entropy.
More information about the thelist
mailing list