Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Left outer join Issue

552509Apr 26 2007 — edited Apr 30 2007

Hi

im having a mapping with a joiner in which im performing Inner joins and also left outer join on different colimns of different tables.
My join condition looks like

tab1.col_a=tab2.col_a and
tab2.col_b=tab3.col_b(+)

like this thr are more than 8 tables involved.

When i generate the query and execute it at the backend i find that its performing right outer join instead of left outer join.

Is this a bug?

Kindly suggest me a workaround for this issue.

Regards
Vibhuti

Locked Post

New comments cannot be posted to this locked post.

Locked on May 28 2007

Added on Apr 26 2007

#data-warehousing, #warehouse-builder

8 comments

1,313 views