Unfortunately I have lots of code like
Select a.bla,b.bla,c.bla
from (taba a join tabb b)left outer join tabc c

The presence of these brackets breaks the parser. I know Helen has told me
that the use of brackets in the 'from' is 'not correct syntax' but I have
been using it for years, it worked in V4.3Aa and it is accepted by the
engine.

I have a huge task getting rid of the brackets especially as a lot of SQL is
generated in code and it is sometimes difficult to see both ends of the
brackets.

Should the parser be 'fixed' or are we officially declaring the use of
brackets in 'from' illegal?

Regards
Paul


[Non-text portions of this message have been removed]