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 total>0;
>
>
>
> Cor
Like this:
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 1 to server version: 4.0.13
Type 'help;' or '\h' for help. Type '\c' to clear the buffer.
umysql> use test;
Reading table information for completion of table and column names
You can turn off this fea
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 total>0;
Cory Hicks wrote:
Hello,
I must be having a goober moment.I am running the following sql
query with no probl
From: Cory Hicks [mailto:[EMAIL PROTECTED]
> Hello,
>
> I must be having a goober moment.I am running the following sql
> query with no problems:
>
> SELECT project_id,
> IF (SUM( time_worked ) > '0.00', SUM( time_worked ),'NULL') AS total
> FROM time_daily
> WHERE user_id = 'clh' AND period
Hello,
I must be having a goober moment.I am running the following sql
query with no problems:
SELECT project_id,
IF (SUM( time_worked ) > '0.00', SUM( time_worked ),'NULL') AS total
FROM time_daily
WHERE user_id = 'clh' AND period_id = '27'
GROUP BY project_id
However, having 'NULL' appear
