Hi Pierre.

This is a known problem with the FoxPro View Designer. You can use either ViewEditor at http://www.geeksandgurus.com or eView which is file #9474 to fix this and other problems that haven't been addressed yet in the FoxPro View Designer.

HTH

Dan

>Hi everyone,
>
> I have a situation where I need to create a view using foxpro view designer. The SQL result should be something like :
>
> Select rates.*,codes.desc,empl.fname,empl.lname ;
> from rates ;
> left join codes on rates.code = codes.code and ;
> left join empl on rates.emplno = empl.emplno ;
> order by rates.emplno
>
>I always get an error because it gives me the following instead of the above code :
>
> Select rates.*,code.desc,empl.fname,empl.lname ;
> from rates ;
> left join codes ;
> left join empl ;
> on rates.code = codes.code and ;
> on rates.emplno = empl.emplno ;
> order by rates.emplno
>
>The error is rates.code not found.
>
>Any help while be appreciated.
>
>Thanks in advance
>
>Pierre Sauvé