SUM and GROUP

Hi


Whats wrong with this statment?

SELECT
FROM `orders` SUM(del) AS TotalPicked
WHERE datepackedtimestamp = '1196640000'
GROUP BY packedby
ORDER BY packedby

I'm trying to end up with a list of a summed up del from each packed by

EG
John 46
Fred 189
Harry 24

Thanks

Brian







------------------------------------------------------------ --------------------
I am using the free version of SPAMfighter for private users.
It has removed 564 spam emails to date.
Paying users do not have this message in their emails.
Try SPAMfighter for free now!

Re: SUM and GROUP

Post removed (X-No-Archive: yes)

Re: SUM and GROUP

"Tom" wrote in message news:fj1joo021is@drn.newsguy.com...
> On Mon, 03 Dec 2007 18:44:46 GMT, Brian wrote...
>>
>>Hi
>>
>>
>>Whats wrong with this statment?
>>
>>SELECT
>>FROM `orders` SUM(del) AS TotalPicked
>>WHERE datepackedtimestamp = '1196640000'
>>GROUP BY packedby
>>ORDER BY packedby
>>
>>I'm trying to end up with a list of a summed up del from each packed by
>>
>>EG
>>John 46
>>Fred 189
>>Harry 24
>>
>>Thanks
>>
>>Brian
>>
>
> Hi Brian,
>
> I think you need to put the column names and functions in the SELECT part
> of
> your query and the table name(s) in the FROM part. If you are using the
> SUM
> function with the GROUP BY, that should get you the totals for 'del'.
>
> Tom


Not sure what i was thinking the SUM(del) AS TotalPicked should have been
before
the FROM, DOH !!!

Brian



------------------------------------------------------------ --------------------
I am using the free version of SPAMfighter for private users.
It has removed 637 spam emails to date.
Paying users do not have this message in their emails.
Try SPAMfighter for free now!