"Rudy Metzger" <[EMAIL PROTECTED]> wrote:
> Better ifnull(sum(amount_paid),0)
Yes, you are right.
>
> Because if you add up a column which contains NULL and NOT NULL values,
> all NULL values are SKIPPED for the calculation.
>
> This implies that if the column ONLY contains NULL values, the re
PROTECTED]
Subject: Re: join query result difference between 3.23.49 and 4.0.13
Doug Reese <[EMAIL PROTECTED]> wrote:
> hello victoria,
>
> thanks for your response. however, the real goal of my question still
> remains unanswered: given my sample data, how would i find the
balanc
t_paid IS NULL, 0, amount_paid))
>
> doug
>
> At 02:53 PM 7/17/2003 +, [EMAIL PROTECTED] wrote:
>>-Original Message-
>>From: Victoria Reznichenko [mailto:[EMAIL PROTECTED]
>>Sent: donderdag 17 juli 2003 10:33
>>To: [EMAIL PROTECTED]
>>Subject: Re:
: donderdag 17 juli 2003 10:33
To: [EMAIL PROTECTED]
Subject: Re: join query result difference between 3.23.49 and 4.0.13
Doug Reese <[EMAIL PROTECTED]> wrote:
>
> query #2
> mysql> SELECT billing.invoice, SUM(amount_paid) AS paid,
(billing.amount -
> SUM(amount_paid)) AS bala
: Re: join query result difference between 3.23.49 and 4.0.13
Doug Reese <[EMAIL PROTECTED]> wrote:
>
> i have what seems to me a very common operation i'm performing. i
need to
> find the balance on an invoice. i was not having any problems until
the
> production serve
Doug Reese <[EMAIL PROTECTED]> wrote:
>
> i have what seems to me a very common operation i'm performing. i need to
> find the balance on an invoice. i was not having any problems until the
> production server was upgraded to mysql v4.0.13-standard for
> pc-linux. there must be a better way
