Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
I hate Joins
Message
Information générale
Forum:
Visual FoxPro
Catégorie:
Problèmes
Titre:
Divers
Thread ID:
00161812
Message ID:
00162157
Vues:
27
Strange. Did you try to change SQL to look like:
>...
>FROM travel!TravAuth ;
>LEFT OUTER JOIN travel!Destination ;
>ON Travauth.destid = Destination.destkey ;
>LEFT OUTER JOIN travel!Accounts ;
>ON Travauth.actid = Accounts.actid ;
>ORDER BY Travauth.empid, Travauth.tanum

BINGO! I just tried that and was going to post that answer. Nesting the Joins is a No-No. I used the view designer first to generate the code I needed (thought it would save time instead of typing it all by hand). The VD nested the joins. Bad VD! Bad VD! VD needs a shot of penicillin :)
Mark McCasland
Midlothian, TX USA
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform