>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.