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

Thank you.