General information
Category:
Reports & Report designer
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
Previous
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only