Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
3 table join
Message
De
17/02/2011 09:39:49
 
 
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Titre:
Versions des environnements
Visual FoxPro:
VFP 8 SP1
Divers
Thread ID:
01500313
Message ID:
01500526
Vues:
33
>>In a full join having the fastest way to calc each line may be important.
>>I'm pretty sure that
select nvl(T.PK, P.PK) as PK, nvl(T.FK, P.FK) AS FK, P.pNo, P.pDesc, T.tno, T.tDesc;
>>from Parts P full join Tools T on P.PK = T.PK and P.FK = T.FK into cursor csrToolsParts
>>
>>
>>is easier on resources and for my taste on the eyes as well ;-)
>
>I'm not exactly sure how does it work. It should work only if for each Main table PK we have sequence numbering without gaps, e.g.
>
>Main PK = 1
>FK = 1, 2, 3 in both tables.

Me neither - full join reasons are rare. At least half full joins I encountered were bugs.
But remapping iif(isnull(T.key), p.key, T.key) should not create problems.
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform