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é