view designer? what's a "view designer"? ;-)
>>>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. :)
Ken B. Matson
GCom2 Solutions