Re: join query result difference between 3.23.49 and 4.0.13

2003-07-17 Thread Doug Reese
: 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

join query result difference between 3.23.49 and 4.0.13

2003-07-16 Thread Doug Reese
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