When opening a script with a long outer join query in the Editor, TOAD shows the following syntax check error:
'ERROR line 1234, col 12, ending_line 1234, ending_col 45, Found 'JOIN', Expecting: JOIN -or- OUTER'
This error can happen if there are comments next to the outer join LEFT clause.
WORKAROUND:
Ensure the keywords are written together in the code e.g. 'LEFT JOIN', rather than being split up by comments.
STATUS:
Waiting for fix in a future release of Toad for Oracle
