Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
I hate Joins
Message
General information
Forum:
Visual FoxPro
Category:
Troubleshooting
Title:
Miscellaneous
Thread ID:
00161812
Message ID:
00162157
Views:
33
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
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform