Hi,
Unfortunately the VFP's view designer can only deal with very simple SQL definitions. That's why I make the views in code.
I know the SQL SELECT statement is correct since I can issue it at the command line and it works perfectly.

Regards


>Raul
>
>Try opening the view in the View Designer to see whether those inner joins have been messed up.
>
>Regards
>
>JR