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 ...
>
Use
DECODE ( CLP.DebitoCredito,
'C', MLPL.Importe,
0) AS Haberes
and so on
Elke
SAP Labs Berlin
