select sum based on fields

[digitalbart2k]

Does anyone know any good tutorials on how to do complex sql queries?

I am try to do this

SELECT * FROM tablea where sum(hours) > 1000 and date1 Between x and x

If anyone has any ideas how this could be done or can point to a place where i could learn how to do this that would be great.

thanks

[tomhath]

This is how I'd write it:

SELECT somefield FROM tablea
where date1 >= x and date1 <= y
group by somefield
having sum(hours) > 1000

[LordShryku]

Your query should work as is...

What error are you getting?