ORA-01468 error, outer join problems Help please 1

[ziggs]

We are changing programs and our existing system uses Oracle 7.3 and the new system uses Oracle 8i. The new database for the program is somewhat similar to before with some changes (some tables and fields renamed). I have several Crystal Reports on the old database, but some of them are having problems when I "Set Location" repoint to new DB. FYI, both ODBC connections are set to use the Microsoft ODBC for Oracle.

I'll use an example of an existing report to explain. I have four tables that I'm collecting data from. Three of the tables are linked to the primary table and is linked by a CaseNumber. For the three tables I have a left outer join to the primary table. This works in the Oracle 7.3 DB fine. However, the same linkage in the 8i DB causes the following error:

ODBC error:[Microsoft][ODBC driver for Oracle][Oracle]ORA-01468: a predicate may reference only one outer-joined.

Looking up this error message, it says to only use one outer join. However, I puzzled as to why I can use three outer joins on the Oracle 7.3 database.

Now, if I only set one of the three tables with an outer join, the report works. However, I don't get all the records that I need.

Am I missing something here? Any help would be appreciated. I can pass on more infomation if needed. I tried to keep this message as short as possible.

 

[ziggs]

BTW, I'm using CR 8.0.

 

[ziggs]

Any ideas?

 

[Ngolem]

Instead of
table 2
/
table 1 - table 3
table 4

can you join them

table 1 - table 2 - table 3 - table 4

instead....you did not mention if they join on the same field or not..

Jim