>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 :)
Wrong. VD needs to be shot. :) I also use VD for quick-and-dirty SQL but always re-write it this way.
:)
Nick Neklioudov
Universal Thread Consultant
3 times Microsoft MVP - Visual FoxPro
"I have not failed. I've just found 10,000 ways that don't work." - Thomas Edison