OBIEE - Right outer join

> Reporting and Data Access Tools > Oracle Business Intelligence (OBIEE/Siebel Analytics) > OBIEE - BI Server (OBIS|nqsserver|nqs)

1 - About

How can we perform a join with the type right outer in OBIEE.

To know what is a right outer join, follow this link : SQL - Right Outer Join

Advertising

3 - In the repository

In the logical join of the business model layer:

3.1 - In the logical Sql

 SELECT A.saw_0, B.saw_0  FROM 
(SELECT Calendar."Calendar Year" saw_0 FROM SH WHERE Calendar."Calendar Year" IN (2000, 2001) )  A RIGHT OUTER JOIN
(SELECT Calendar."Calendar Year" saw_0 FROM SH WHERE Calendar."Calendar Year" IN (1999, 2000, 2001) )  B ON A.saw_0 = B.saw_0