Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Proper syntax for a compound join
Message
Information générale
Forum:
Visual FoxPro
Catégorie:
Codage, syntaxe et commandes
Titre:
Proper syntax for a compound join
Divers
Thread ID:
00247208
Message ID:
00247208
Vues:
68
I have 2 tables that need a compound join for proper results.

Custno + Cshipno are identical in both tables

Would you :

Regular stuff here : ;
FROM ves!master2 LEFT OUTER JOIN arcadr01 ;
ON Master2.custno = Arcadr01.custno ;
where Master2.cshipno = Arcadr01.cshipno ;

or :


FROM ves!master2 LEFT OUTER JOIN arcadr01;
LEFT OUTER JOIN ves!master2 ;
ON Master2.cshipno = Arcadr01.cshipno ;
ON Master2.custno = Arcadr01.custno ;
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform