In CR 8.5, I had a report that left outer joined 6 tables together.
5 of them reside in the same database and 1 resides in another database. I will refer to tables as A, B, C, D, and E. The query produced by 8.5 using left outer joins was:

select distinct
A.Field1 B.Field1, C.Field1, D.Field1, E.Field1
FROM
DB1@Server:owner.A A
outer DB1@Server:owner.B B
outer DB1@Server:owner.C C
outer DB1@Server:owner.D D
outer DB2@Server:owner.E E

CR XI produces an entirely different query:

select distinct
A.Field1 B.Field1
FROM
DB1@Server:owner.A A
outer DB1@Server:owner.B B

select distinct C.Field1
From C

Select distinct D.Field1
From D

Select distinct E.Field1
From E

It is only outer joining the first two tables and then seperating the rest into seperate queries. Is this a bug within Crytal XI? Does anyone have a solution?

Thanks,
Saied