MySQL Forums
Forum List  »  Spanish

Re: sub query?
Posted by: alvaro salinas
Date: September 06, 2007 09:18AM

gracias por la ayuda, ya lo hice pero porque mi query es el siguiente

SELECT vol_corr, vol_cod,
SUM(ifnull(vol_retus,0)),
SUM(ifnull(vol_depus,0)),
SUM(ifnull(vol_depus,0)-ifnull(vol_retus,0))
FROM bono
GROUP BY vol_cod

pero me los agrupa por vol_cod, y no puedo ver el detalle de las fechas de ese vol_cod

EL SUM(ifnull(vol_depus,0)-ifnull(vol_retus,0)) es el saldo que mencionaba antes
(nota:con where el query me daba error)

Options: ReplyQuote


Subject
Views
Written By
Posted
3325
September 05, 2007 11:37PM
1958
September 06, 2007 08:02AM
Re: sub query?
2535
September 06, 2007 09:18AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.