[sqlite] using sqlite calculated field

[Esteban Cervetto]

this query fail:
Because I am trying to use the IPPD calculated field. How can i do this?
Thanks


SELECT
  datsiniestros.grupo,
  datsiniestros.siniestro,
  datsiniestros.ibm,
  datsiniestros.edad,
  datsiniestros.porinc,
  datsiniestros.sexofem,

  (CASE sexofem
    WHEN 'False' THEN parrentas.masc_ippd
    ELSE parrentas.fem_ippd
  END) AS IPPD,
  (CASE sexofem
    WHEN 'False' THEN parrentas.masc_iptd
    ELSE parrentas.fem_iptd
  END) AS IPTD,

  (CASE GRUPO
  WHEN  2 THEN 0 /*RECHAZOS*/
  WHEN  3 THEN 0 /*LEVES*/
  WHEN  4 THEN (53*PORINC*100*IBM*65 /datsiniestros.edad)  /*O-50*/
  WHEN  5 THEN (53*PORINC*100*IBM*65 /datsiniestros.edad)  /*O-50*/
  WHEN  6 THEN (53*PORINC*100*IBM*65 /datsiniestros.edad)  /*O-50*/
  WHEN  7 THEN (53*PORINC*100*IBM*65 /datsiniestros.edad)  /*O-50*/
  WHEN  8 THEN (53*PORINC*100*IBM*65 /datsiniestros.edad)  /*O-50*/
  WHEN  9 THEN (IBM*IPPD+80000) /*5O-66*/
  WHEN 10 THEN (53*IBM*65 /datsiniestros.edad + 100000) /*>66*/
  WHEN 11 THEN (53*IBM*65 /datsiniestros.edad + 100000+2000*1.25*IPTD)
/*GI*/
  WHEN 12 THEN (53*IBM*65 /datsiniestros.edad + 120000)  /*MUERTE*/
  END) AS 'INDEM'

FROM datsiniestros
  INNER JOIN parrentas ON
    (datsiniestros.edad = parrentas.edad)
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users