Sintaxis de Scrip para Foxpro
Publicado por Jaime A. Paredes (12 intervenciones) el 13/05/2017 22:18:02
Amigos, tengo una inconveniente, tengo una script de Mysql, las que les menciono lineas a bajo, pero ahora quiero hacerlo pero en V.foxpro9 tengo dudas al hacer no me sane en nada, se que estoy herrado quisiera que me apoyen de pasar este script de mysql a foxpro
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
SELECT
cod_2015.CODIGO,
cod_2015.PLAZA,
cod_2015.COD_ESTAB,
cod_2015.SEXO,
cod_2015.FECHA,
bd_cie.DESC_ENF,
COUNT(CASE WHEN (cod_2015.edad Between 0 AND 28 ) THEN 'De 0 a 28 d¡as (RN)' END) AS 'De 0 a 28 d¡as (RN)',
COUNT(CASE WHEN (cod_2015.edad Between 29 AND 61 ) THEN 'De 29 d¡as a 11 meses' END) AS 'De 29 d¡as a 11 meses',
COUNT(CASE WHEN (cod_2015.edad Between 101 AND 101) THEN 'De 1 a¤o' END) AS 'De 1 a¤o',
COUNT(CASE WHEN (cod_2015.edad Between 102 AND 102) THEN 'De 2 a¤os' END) AS 'De 2 a¤os',
COUNT(CASE WHEN (cod_2015.edad Between 103 AND 103) THEN 'De 3 a¤os' END) AS 'De 3 a¤os',
COUNT(CASE WHEN (cod_2015.edad Between 104 AND 104) THEN 'De 4 a¤os' END) AS 'De 4 a¤os',
COUNT(CASE WHEN (cod_2015.edad Between 105 AND 109) THEN 'De 5 a 9 a¤os' END) AS 'De 5 a 9 a¤os',
COUNT(CASE WHEN (cod_2015.edad Between 110 AND 114) THEN 'De 10 a 14 a¤os' END) AS 'De 10 a 14 a¤os',
COUNT(CASE WHEN (cod_2015.edad Between 115 AND 119) THEN 'De 15 a 19 a¤os' END) AS 'De 15 a 19 a¤os',
COUNT(CASE WHEN (cod_2015.edad Between 120 AND 149) THEN 'De 20 a 49 a¤os' END) AS 'De 20 a 49 a¤os',
COUNT(CASE WHEN (cod_2015.edad Between 150 AND 164) THEN 'De 50 a 64 a¤os' END) AS 'De 50 a 64 a¤os',
COUNT(CASE WHEN (cod_2015.edad Between 165 AND 199) THEN 'De 65 a mas a¤os' END) AS 'De 65 a mas a¤os',
count(cod_2015.CODIGO) as Total
FROM
cod_2015
Inner Join bd_cie ON cod_2015.CODIGO = bd_cie.CIEX2 GROUP BY cod_2015.CODIGO, cod_2015.COD_ESTAB, cod_2015.SEXO
ORDER BY
count(cod_2015.CODIGO) DESC
Valora esta pregunta
0
