title: How to effectively "outer join" two data sources (SQL queries) in OBIEE 11g data model?
body: <p>I have two SQL queries in a data model, each for a different data source. I am trying to link one to another to the effect that creating a report with all columns will not exclude values not matching in each of the queries. Simply linking elements seems to "inner join" when creating a report (excludes values which do not match in both queries). I am looking to essentially "left join" one source with another in report creation - I WANT null values to display from the other source.</p>
  
  <p>When I review the data in the data model itself (via the data tab) null values are showing. It is only in the report creation that I am having this problem.</p>
  
  <p>I am not a DBA and have read-only database access. I do not have access to any OBIEE desktop tools.</p>
  
  <p><a href="https://i.stack.imgur.com/JhZkS.png" rel="nofollow noreferrer">Example</a></p>