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