Hi,
have a look at the Decode function.Yves
Alejandro D. Burne wrote:
Is there any logical function (IF ????) to translate this sentence???
SELECT MONTH(MLPL.FechaComprobante) AS Mes, SUM(IF(CLP.DebitoCredito='C',MLPL.Importe,0)) AS Haberes, SUM(IF(CLP.DebitoCredito='D',MLPL.Importe,0)) AS Deducciones, SUM(IF(CLP.CodigoConceptoLiqProf=270,MLPL.Importe,0)) AS InstBecario, SUM(IF(CLP.CodigoConceptoLiqProf=395,MLPL.Importe,0)) AS Ganancias FROM MovimientosLiqProfesionales MLP INNER JOIN MovimientosLiqProfesionalesLiquidados MLPL
ON MLP.CodigoMovLiqProf=MLPL.CodigoMovLiqProf
INNER JOIN ConceptosLiqProfesionales CLP
ON MLP.CodigoConceptoLiqProf=CLP.CodigoConceptoLiqProf WHERE ...
_________________________________________________________________
<http://www.incredimail.com/redir.asp?ad_id=310&lang=10> IncrediMail - El E-mail ha evolucionado finalmente - Haga clic aqu� <http://www.incredimail.com/redir.asp?ad_id=310&lang=10>
-- Yves Trudeau, Ph. D. Analyste syst�me T�treau Dumont Trudeau consultants inc.
-- MaxDB Discussion Mailing List For list archives: http://lists.mysql.com/maxdb To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
