Hi,
I'm running Mysql 4.01 on mandrake 8.2 with all production data
using InnoDB type.
I've a field named "dch_pri" contain some account transaction data in
format of DECIMAL (14,2).
When running following query:
SELECT din_no, SUM(IF(tran_type = "D", dch_pri, -dch_pri)) AS dch_sum
FROM pa_ch2
WHERE x_status IN ("", "C")
AND dch_acc IN ('231000', '310000')
GROUP BY din_no
HAVING dch_sum # 0
It remove all record that contain absolute value between 0 and 0.99
Change query to:
SELECT din_no, SUM(IF(tran_type = "D", dch_pri, -dch_pri)) AS dch_sum
FROM pa_ch2
WHERE x_status IN ("", "C")
AND dch_acc IN ('231000', '310000')
GROUP BY din_no
HAVING dch_sum <> 0
It will retain all result record which dch_sum = 0
Change the HAVING dch_sum # 0 to HAVING dch_sum # 0.00
Or
Change the HAVING dch_sum <> 0 to HAVING dch_sum <> 0.00
Doesn't improve.
Any idea?
---------------------------------------------------------------------
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
