Symptom
Crystal Reports (CR) 9
An error message referencing join syntax appears when linking tables in a report or previewing a report.
Cause
The correct SQL syntax for a Left Outer join is required.
The SQL syntax for using a Left Outer join varies according to the database type.
The error messages vary depending on the database type.
Resolution
For a list of the correct SQL syntax for a Left Outer Join and instructions on how to troubleshoot this issue, refer to the technical paper How to resolve join syntax errors in Crystal Reports 9.
For CR 8.5 and earlier, please refer to Note 1212698.
Keywords
LEFT OUTER JOIN ODBC JOINBUILDER REGISTRY OUTERJOIN SQL SYNTAX ERROR OJ Crystal Reports Join Syntax Outerjoin issues , c2012113 , KBA , BI-RA-CR , Crystal Reports designer or Business View Manager , Problem