Right Outer join does not work

[Maniyur]

I have 10 tables in a report in which one join is Right Outer Join.

I have removed all selection criteria to test this with only joins and it does not work. I am using Oracle 9 with CR8.5.

Please help

 

[synapsevampire]

Check the Database->Show SQL Query to see what is being passed.

A RO does work in Crystal, so perhaps there's a misunderstanding?

-k

 

[Maniyur]

I have looked at the SQL and it looks OK. (+) sigh is put on the right colum for the join.

The scenario is this.

Out of 10 tables which are joined there are 3 main tables ISSUE, CONTACT and COUNTY.

ISSUE to CONTACT is equi join
CONTACT to COUNTY is right join.

The objective is to bring in and diaplsy all counties even if there are no issues assiciated with any contacts within that county.

When I made both joins as right joins it worked but brought lot os unwanted records.

Does this clarify the problem? Any help is greatly appreciated.

 

[synapsevampire]

Why not go County Left Outer to Contact, Contact Left Outer to Issue if you want all Counties?

-k

 

[Maniyur]

Figured it out.

Joined the county table with a subselect of all other table joins.

Thanks for all youe help.