>>Yes, the subject of this thread is correct. I get it whenever I try to create a left join in View Designer using MS SQL tables as datasource. The code generated by view designer looks like this:
>>
>>

>>SELECT * FFROM table1 {oj LEFT JOIN table2 ON table1.id = table2.fkId}
>>

>>
>>As long as i am in View Designer, the view behaves ok, it can be saved, I can USE it, but I can't modify it again, because I get "Syntax error". I tried to delete that {oj from SQL window, but view designer keeps putting it back.
>
>Hi Grigore,
>
>The SQL window doesn't reverse engineer the code so changes there won't be saved. However, what I'd do is copy the code from there, fix it and save it in a PRG, and run the PRG to create the view.

I've had this same problem and have been working around it the same way you are. Is this a foxpro bug or is there something else to this I'm missing?