Hi. I have this query:
Basically (sales+tax)-paid gives me the balance of the account. The problem is MySQL is giving me rows like this in the result (example):
select arrival,id,(sales+ taxes) as sale,paid
where filestat > 10
and ((sales+taxes) - paid) >0 order by 1 LIMIT 0, 100
sales = 100,51 , tax=15,11 (115,62 total price)... paid 115,62. So that row should not be there, in the result. Column types are DECIMAL 10,2.
Whats going on!?!?!?!? I'm using MySQL 4.0.20-standard