Skip to Content
Former Member
Jun 22, 2009 at 03:22 PM

Problems with INNER JOINS under Oracle 9i database


Hello all,

My problem is related about the generation of the SQL query for a Oracle 9i database from Crystal Reports 2008. The generation of reports gets the data through ODBC connected to Oracle 9i database, which supports the execution of SQL querys that use the INNER JOIN command for one SELECT query on different tables at the same time. The trouble comes when the query contains too much INNER JOINs. Crystal returns the error: Failed to retrive data from the database. Details: [Database Vendor Code: 1445] .I have test the same query rewritten in the WHERE form (the JOIN is represented in the WHERE clause) and works right. How Can I change some option in Crystal reports 2008 to generate the SQL query througt WHERE clause instead of INNER JOIN?