>Hello,
>
>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.
>
>How to get the rid of it? it's very frustrating...
You have two F in FROM.