Hello , I hope you could help me. I have a small difference in te result of this query
QUERY
SELECT `an0300_polizas_desgloce`.cuenta,
`an0200_polizas`.fecha,
sum(`an0300_polizas_desgloce`.debito),
sum(`an0300_polizas_desgloce`.credito),
(sum(`an0300_polizas_desgloce`.debito)-sum(`an0300_polizas_desgloce`.credito)),
an0100_cuentas.nombre
FROM `an0100_cuentas`
INNER JOIN `an0300_polizas_desgloce` ON (`an0100_cuentas`.cuenta =
`an0300_polizas_desgloce`.cuenta) INNER JOIN `an0200_polizas` ON
(`an0300_polizas_desgloce`.id_poliza = `an0200_polizas`.id_poliza)
WHERE (
(`an0300_polizas_desgloce`.cuenta = '110201000')
and
(`an0200_polizas`.fecha like '2004-01-%')
)
GROUP BY `an0300_polizas_desgloce`.cuenta
ORDER BY `an0300_polizas_desgloce`.id_poliza
RESULT
cuenta |fecha |sum_debito | sum_credito |total | nombre
110201000 |04/01/23 |410336.6 | 413758.07 |-3421.46 | HSBC
As you could see, if you substract 410336.6 to 413758.07 the result is -3421.47 Why
the result that mysql show me in the total column is different?
---------------------------------
Do You Yahoo!?
Yahoo! Net: La mejor conexión a internet y 25MB extra a tu correo por $100 al mes.
