>>Can someone explain why I get an error from:
>>SELECT Travauth.travid, Travauth.actid, Travauth.empid, ;
>> Travauth.tanum, Travauth.dcn, Travauth.amount, ;
>> Travauth.bgndate, Travauth.enddate, Travauth.destid, ;
>> Accounts.account, Accounts.allotment, Destination.city, ;
>> Destination.state ;
>> FROM travel!TravAuth ;
>> LEFT OUTER JOIN travel!Destination ;
>> LEFT OUTER JOIN travel!Accounts ;
>> ON Travauth.actid = Accounts.actid;
>> ON Travauth.destid = Destination.destkey;
>> ORDER BY Travauth.empid, Travauth.tanum
>>
>>The error is:
SQL: Column 'ACTID' is not found>>
>>If I switch the order of the JOIN and ON statements, I get the error:
>>
>>
SQL: Column 'DESTID' is not found>>
>>If I have the source tables open before I issue the command, it works. All fields exist, and I can create the view in View Designer. Once I save and exit the designer, I can not edit it in View Designer because I get the error.
>>
>>Once the view is created, the source tables have to be open before I open the view.
>>
>>TIA.
>Mark,
>Try with ON's in order Destination, accounts, travauth.
>Cetin
Pls ignore previous message, missed the order in long SQL :(
Cetin