|
|
|
FairCom DB SQL has supported a RIGHT OUTER JOIN clause with an alternate syntax as follows:
SELECT * FROM T1, T2 WHERE T1.C1 (+) = T2.C3;
In a right outer join, the information from the table on the right is preserved: the result table contains all rows from the right table even if some rows do not have matching rows in the left table. Where there are no matching rows in the right table, FairCom DB SQL generates null values.
A better syntax, much more convenient for SQL developers, is to explicitly state the condition in a SQL statement using the full syntax of RIGHT OUTER JOIN. FairCom DB SQL has been enhanced to allow this new syntax.
