]
_
IncrediMail - El Email ha evolucionado finalmente - Haga clic aqu
--
Cory Hicks [EMAIL PROTECTED]
TRI International
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
where the total is 0.00 doesn't do me much
good :-) How do I write this query to only show me the results where the
total is 0.00...so where the results that total 0.00 don't appear at
all.
I am sure I am missing something...thanks for any help!
Cory
--
Cory Hicks [EMAIL PROTECTED]
TRI
That did the trickthanks so much!
Cory
On Wed, 2004-01-14 at 12:50, Douglas Sims wrote:
Would something like this do what you want?
SELECT project_id, SUM(time_worked) AS total FROM time_daily WHERE
user_id='clh' AND period_id='27' GROUP BY project_id HAVING total0;
Cory Hicks
.- Invalid use of group function -
I don't want to pull out any rows where the SUM of time_hours_worked is
'0.00'...
I would be most grateful if anyone has any suggestions
Many thanks!
Cory
--
Cory Hicks [EMAIL PROTECTED]
TRI International
--
MySQL General Mailing List
For list archives
, the id, but I get no results.
Advice? Helpful hints always welcome..
Many thanks!
Cory
--
Cory Hicks
Texas Research International, Inc.
[EMAIL PROTECTED]
-
Before posting, please check:
http://www.mysql.com/manual.php
Duh! I need '' around my datesorry for the traffic.
sql, query
Duh!
--
Cory Hicks
Texas Research International, Inc.
[EMAIL PROTECTED]
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual
/ (the list archive)
To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
--
Cory Hicks [EMAIL PROTECTED]
TRI-International
]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
--
Cory Hicks [EMAIL PROTECTED]
TRI-International
-
Before posting, please check:
http://www.mysql.com/manual.php
Jeff,
Try a JOIN:
http://www.mysql.com/doc/en/JOIN.html
or for some good articles:
http://www.onlamp.com/pub/ct/19
HTH!
Cory
On Fri, 2002-11-01 at 10:01, jeff wrote:
Hello
I am having some trouble writing a query that will pull the information I
need from the database. I hope it's