|
|
Posted by Tom on 12/03/07 19:00
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
--
NewsGuy Accounts Go Jumbo!
NewsGuy Express increased from 30 to 50 GB of download capacity
http://newsguy.com/overview.htm
Navigation:
[Reply to this message]
|