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.
Grigore Dolghin
Class Software.