On Fri, Mar 09, 2001 at 08:13:24AM -0600, Gerald L. Clark wrote:
> I think you meant
> select sum(deci) as s where deci<0;
> > select sum(deci) as s from deci having s<0;
No, I really meant my SELECT. MySQL counted the 3 values together but
instead of coming to the conclusion that the sum is zero it showed me
-0.00 as output by in a comparision to 0 the "output" of the sum(deci)
was *not* 0 but something different.
(I wanted to see how many customers with open or unbalanced invoices we
have and mysql always gave me a much to high number because it made
rouding errors when adding the sums)
bye,
-christian-
--
Christian Hammers WESTEND GmbH - Aachen und Dueren Tel 0241/701333-0
[EMAIL PROTECTED] Internet & Security for Professionals Fax 0241/911879
WESTEND ist CISCO Systems Partner - Premium Certified
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (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