Skip to Main Content

Analytics 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!

Forcing an Outer Join that doesn't exist in the EUL

989324Apr 29 2013 — edited Jun 20 2013
I am running Discoverer Plus and they do not give me any access to anything. We have a table join that should be an outer, but it was not created that way in the EUL. So when we try to create the report we want, it works fine until we add the fields from the table that was joined incorrectly.
we have the follwing:
Analyte Table containing Analyte_CLASS_ID that is a NOT NULL field.
Analyte_CLASS Table containing ANALYTE_CLASS_ID and ANALYTE_CLASS_NAME
When I want the NAME, I simply add to the report, but it then wipes out any Analyte_Table.Analyte_CLASS_ID's that are NULL.

Is there something that I can do to work around this? I have put in for there to be an OUTER JOIN added to those two fields, but in reality who knows when that will be done.
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jul 18 2013
Added on Apr 29 2013
1 comment
323 views