Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
SQL - Litle problem...
Message
De
13/04/2000 21:15:29
 
 
À
13/04/2000 21:12:51
Cetin Basoz
Engineerica Inc.
Izmir, Turquie
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Divers
Thread ID:
00359564
Message ID:
00359604
Vues:
8
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
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform