SAP Knowledge Base Article - Public

1215332 - Correct SQL syntax for a Left Outer join in Crystal Reports 9


Crystal Reports (CR) 9

An error message referencing join syntax appears when linking tables in a report or previewing a report.


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.


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


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


SAP Crystal Reports 9.0