Hi Cindy

Ignore my last post to you, i solved that part of sql

i have the test only with the document number
lcP="000001"
lcU="000005"
and i need like that, and the sql run ok
lcP="010101000001"
lcU="010101000005"


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

Now i need to join more two tables here, clients with client_name and tipodoc with the name_document, what's the way i could do that? The ClientID is in my table 'documentoscabcli' and my tipodoc.ID to.

Thank's in Advance

João Batista