Cindy,

Your code give me an error keyword phrase error....

with this code only, i get what i want, the only five documents, but i need that in the other way because i can have the doc number 5 in more than one cod_ser and in other c_armazem.



lcP="000001"
lcU="000005"

SELECT * ;
FROM DOCUMENTOSCABCLI A, DOCUMENTOSLINCLI B;
WHERE A.C_TIPODOC = B.C_TIPODOC;
AND BETWEEN(A.C_NUMDOC, lcP, lcU) ;
INTO CURSOR DOCUMENTOS

If you can help-me to construct the sql i apreciate,

Thank's in Advance

João Batista