João,

To add more tables, just put them in the WHERE clause, however they relate to your previously mentioned tables.

Watch out when using SELECT *, since SQL renames repeated fields. It's worth taking the time to type out only the ones you really want. Also, when retrieving a lot of data from a server (which we sometimes do for a report), eliminating duplicate fields can save time since data coming over the wire may be the slowest part of the process.


>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