Syntax check on a long outer join query shows an error: 'Found 'JOIN', Expecting: JOIN -or- O (4241462)

Chat now with support

Return

Feedback Submitted

Did this article solve an issue for you?

Select Rating

Title

Syntax check on a long outer join query shows an error: 'Found 'JOIN', Expecting: JOIN -or- O
Description

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'
Cause

This error can happen if there are comments next to the outer join LEFT clause.
Resolution

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
Defect ID

ST 65261

Feedback Submitted

Did this article solve an issue for you?

Select Rating

Title