>>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.
>:)

An even better idea. :)