Information générale
Catégorie:
Codage, syntaxe et commandes
Thanks Chaim, I'll see if I can find the articles at the FoxPro Advisor site.
One of the queries I have is illustrated by this example:
FROM table_A JOIN table_B ON table_A.x = table_B.x ;
JOIN table_C ON table_A.x = table_C.x ;
Is table_C being joined on table_A or on the result set of the first join?
Also, the above syntax seems to process much faster than the following equivalent which was produced by the Query designer :
FROM table_A JOIN table_B JOIN table_C ;
ON table_A.x = table_B.x ;
ON table_A.x = table_C.x ;
Is there a trap in the first method that I haven't fallen into yet...?
Précédent
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement