SAP Knowledge Base Article - Public

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

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

Product

SAP Crystal Reports 9.0