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.
