20/12/2011, 00:02
|
| | | Fecha de Ingreso: julio-2009
Mensajes: 29
Antigüedad: 14 años, 9 meses Puntos: 0 | |
| Duda con Consulta SQL
Hola!,
Tengo algo que me esta rompiendo la cabeza..
Tengo una tabla con pagos de usuarios:
id_user_paid id_user user_paid paid_date
1 9 0.00 2011-12-20
2 8 1.00 2011-12-20
y la siguiente consulta:
SELECT users_data.num_doc, CONCAT(users_data.last_name, ', ', users_data.first_name) AS nombre,
CONCAT('$', ROUND( (training.training_cost - (training.training_cost * payment_plans.payment_plan_discount / 100)),2)) AS tot_a_pagar,
CONCAT('$', ROUND( SUM(users_payment.user_paid), 2)) AS tot_pagado,
CONCAT('$', ROUND( (training.training_cost - (training.training_cost * payment_plans.payment_plan_discount / 100)) - (SUM(users_payment.user_paid)),2)) AS saldo,
MAX(users_payment.paid_date) AS ultimo_pago
FROM users_data
JOIN users_payment ON users_data.id_user = users_payment.id_user
JOIN users_payment_plans ON users_data.id_user = users_payment_plans.id_user
JOIN payment_plans ON users_payment_plans.payment_plan_id = users_payment_plans.payment_plan_id
JOIN users_trainings ON users_data.id_user = users_trainings.id_user
JOIN training ON users_trainings.id_training = training.training_id
GROUP BY users_data.num_doc
el campo tot_pagado tendria que ser 1,00 pero me sale 4,00..
Porque puede ser? |