>I struggled with this same problem, and though I still didn't figure it out completely I can tell you this :
>
>a. the generate SQL command meets the rules of standard SQL.
>
>b. the view designer generates an error on the SQL command it generates but the SQL command executes correctly ; try to copy and paste it in the command window : it will work. The viewdesigner refuses to save this view, and I still didn't find out how to force it.
>
>c. the work around I use for now (hoping to find a better solution one day, maybe with this thread), is to put the second joincondition (which one doesn't matter) in the where clause.

Pascal,

The VFP view designer is very limited as Waleed noted. Another alternative that I am suggesting is to use xCase. It maintains your data moddel out of VFP and among its interesting features its views capabilities are much, much better.

José