Kbase 19606: Support for Right Outer Join in version 9
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
17/03/2000 |
|
Title: Support for Right Outer Join in version 9
Kbase Number: 19606
This document applies to: SQL-92
Version and Release Number: version 9.x
There are two ways to implement OUTER JOINS in SQL.
* In the FROM clause of the SELECT statement
* In the WHERE clause of the SELECT statement
LEFT OUTER JOINS are supported by both of the ways.
RIGHT OUTER JOINS are only supported in the WHERE clause. That means you can not use the words 'RIGHT OUTER JOIN' to specify the join.
* How are RIGHT OUTER JOINS implemented using WHERE clause? -
In the WHERE clause of a SELECT statement, specify the outer join operator (+) after the column name of the table for which rows will not be preserved in the result table.
Example:
SELECT Customer.Name, SalesRep.RepName
FROM pub.Customer, pub.SalesRep
WHERE Customer.SalesRep(+) = SalesRep.SalesRep
AND Customer.Balance > 40000
Reference to written documents:
SQL-92 Guide and Reference Manual.
Bug #19990716-052 - Right Outer Join not supported in SQL-92
Bug #19990716-048 - Doc bug for Right Outer Joins support