AW: Help with #1111 - Invalid use of group function

2003-09-05 Thread Franz, Fa. PostDirekt MA
Hi, >SELECT TD.project_id, P.project_manager >FROM time_daily TD >INNER JOIN projects P ON P.project_id = TD.time_project_id >WHERE TD.time_user_id = 'xpt' AND ( >SUM( TD.time_hours_worked ) <> '0.00' an Paul Dibois said: You cannot use aggregate functions like SUM() in the WHERE clause. And He i

Re: Help with #1111 - Invalid use of group function

2003-09-04 Thread Diana Soares
Hi! Try this: SELECT TD.project_id, P.project_manager, SUM( TD.time_hours_worked ) as hours FROM time_daily TD INNER JOIN projects P ON P.project_id = TD.time_project_id WHERE TD.time_user_id = 'xpt' HAVING hours <> '0.00' Hope this helps! On Wed, 2003-09-03 at 17:24, Cory Hicks wrote:

Re: Help with #1111 - Invalid use of group function

2003-09-04 Thread Sebastian Haag
Hi, Paul DuBois said: > At 11:24 -0500 9/3/03, Cory Hicks wrote: >>Hey folks, >> >>I am trying to run the following sql query in mysql: >> >>SELECT TD.project_id, P.project_manager >>FROM time_daily TD >>INNER JOIN projects P ON P.project_id = TD.time_project_id >>WHERE TD.time_user_id = 'xpt' AND

Re: Help with #1111 - Invalid use of group function

2003-09-03 Thread Sebastian Haag
Sorry, I think it should be GROUP BY TD.project_id, P.project_manager Cory Hicks said: > Hey folks, > > I am trying to run the following sql query in mysql: > > SELECT TD.project_id, P.project_manager > FROM time_daily TD > INNER JOIN projects P ON P.project_id = TD.time_project_id > WHERE TD.

Re: Help with #1111 - Invalid use of group function

2003-09-03 Thread Sebastian Haag
Cory, Cory Hicks said: > Hey folks, > > I am trying to run the following sql query in mysql: > > SELECT TD.project_id, P.project_manager > FROM time_daily TD > INNER JOIN projects P ON P.project_id = TD.time_project_id > WHERE TD.time_user_id = 'xpt' AND ( > SUM( TD.time_hours_worked ) <> '0.00' >

Re: Help with #1111 - Invalid use of group function

2003-09-03 Thread Paul DuBois
At 11:24 -0500 9/3/03, Cory Hicks wrote: Hey folks, I am trying to run the following sql query in mysql: SELECT TD.project_id, P.project_manager FROM time_daily TD INNER JOIN projects P ON P.project_id = TD.time_project_id WHERE TD.time_user_id = 'xpt' AND ( SUM( TD.time_hours_worked ) <> '0.00'

Help with #1111 - Invalid use of group function

2003-09-03 Thread Cory Hicks
Hey folks, I am trying to run the following sql query in mysql: SELECT TD.project_id, P.project_manager FROM time_daily TD INNER JOIN projects P ON P.project_id = TD.time_project_id WHERE TD.time_user_id = 'xpt' AND ( SUM( TD.time_hours_worked ) <> '0.00' ) And I keep getting the # errno