: 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
hello,
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 to query for this information than
the m