2848201 - Error "Failed to retrieve data from the database" when refreshing a report based off Rocket U2 DB in Crystal Reports

• Failed to add a second table to report
• After joining two tables in Crystal Reports received the following error:

Failed to retrieve data from the database.

Details: S1000:[Rocket U2][U2ODBC][1401263]Error ID: 29

Severity: ERROR Facility: FPSRVERR - Line 1, column 206

(around "INNER"): Syntax error.

• SAP Crystal Reports 2016
• Rocket U2 database
• U2 ODBC driver

Join Syntax, failure , KBA , BI-RA-CR , Crystal Reports designer or Business View Manager , Problem