General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
Hi Cetin,
With my last post i remove the lines that have '***' and it work's, now i think is the join clause is not in that way, what did you think?
SELECT * ;
FROM jbfic!documentoscabcli INNER JOIN jbfic!documentoslincli ;
on Documentoscabcli.c_tipodoc = documentoslincli.c_tipodoc;
AND Documentoscabcli.c_armazem = documentoslincli.c_armazem;
AND Documentoscabcli.c_cod_ser = documentoslincli.c_cod_ser;
AND Documentoscabcli.c_numdoc = documentoslincli.c_numdoc;
AND BETWEEN(Documentoscabcli.C_TIPODOC+Documentoscabcli.C_ARMAZEM+Documentoscabcli.C_COD_SER+Documentoscabcli.C_NUMDOC, lcP, lcU) ;
*** LEFT OUTER JOIN jbfic!documentos ;
LEFT OUTER JOIN jbfic!clientes ;
*** ON Documentoscabcli.c_tipodoc = Documentos.c_codigo ;
ON Documentoscabcli.c_codcli = clientes.c_codigo ;
ORDER BY Documentoscabcli.c_tipodoc, Documentoscabcli.c_armazem,;
Documentoscabcli.c_cod_ser, Documentoscabcli.c_numdoc;
into cursor fact
Thank's in Advance
João Batista
Previous
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