SELECT MAX(V.fecierre) AS pivote, ; H.numpoliz, H.codmodal,M.codrease, C.nombre, ; C.apellid1, C.apellid2,C.tipdocid, C.numident, ; C.fecnacim,(H.edactuin + H.anualida)-1 AS edactuin, ; C.sexo,H.fecinpol AS fecinief,H.durseg, ; H.fecfinef, ; IIF(H.codfpago = '9','PU',ALLTRIM(STR(H.durpri))) AS durpri, ; H.codfpago,H.fecefsit,H.anualida,H.moneda, ; H.sitpoliz, ; IIF (H.sitpoliz = '10','NO','SI') AS vigreduc, ; H.motsitua,H.fecanula,H.fecbaja AS fecconan, ; E.codclien ; FROM ppolizas P, phpoliza H, pmodalid M, phpolper E, pcligrls C, pprovpol V ; WHERE P.numpoliz = V.numpoliz and ; (P.sitpoliz = "00") and ; (H.numpoliz = V.numpoliz) and ; (H.numsuple = V.numsuple) and; (M.codmodal = H.codmodal) and (!EMPTY(M.codrease)) and ; ((E.numpoliz = V.numpoliz) and (E.tiporela = 'A')) and; (E.codclien = C.codclien); GROUP BY H.numpoliz ; ORDER BY H.numpoliz, H.codmodal, H.numsuple DESC ; INTO CURSOR cur_cartera_vigThe difference is that I get incorrect values for the H.fecefsit and H.anualida cursor fields. Both values (correct and wrong) are saved on the phpoliza table, so it's like my original WHERE clause was distorted in some way.