|
|
Posted by Brian on 12/05/07 01:06
"Tom" <tom@to.com> 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!
Navigation:
[Reply to this message]
|