|
|
Posted by Ray Greene on 10/13/05 04:36
On 12 Oct 2005 03:03:24 -0700, "David Portas"
<REMOVE_BEFORE_REPLYING_dportas@acm.org> wrote:
>Don't assume it is obvious what is wrong. It helps to say exactly what
>error message you got and also to post enough code to reproduce the
>problem - at least a CREATE TABLE statement.
OK, I'll do that in future.
>In this case you missed the GROUP BY:
>
>SELECT location, machinename, SUM(hours)
> FROM tbl
> WHERE date >= '20050101'
> AND date < '20060101'
> GROUP BY location, machinename ;
Well that was simple enough compared to what I was trying to do.
I had assumed that it would take a nested query, I guess I shouldn't jump to
conclusions when I don't know what I'm doing :-)
>It is usually easier to specify date ranges as >= and < unless you are
>sure that the DATETIMEs will never contain times other than midnight.
Good point, I'll do it that way.
Thanks for the help David, it's much appreciated.
-
Ray Greene.
Navigation:
[Reply to this message]
|