RE: Translate SQL script from MySQL to MaxDB

[Elke Zabach]

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