Kbase P5038: Cannot perform Right Outer Join in SQL-92
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
28/11/2007 |
|
Status: Verified
FACT(s) (Environment):
Progress 9.x
OpenEdge 10.x
SYMPTOM(s):
Can not perform Right Outer Join in SQL-92
Sorry, operation not yet implemented. (7484)
CAUSE:
Enhancement request# 20020829-008
FIX:
This Enhancement has not been implemented in the product.
Progress SQL-92 does not support RIGHT OUTER JOINS in the FROM clause of the SELECT statement. It only supports RIGHT OUTER JOINS in the WHERE clause.
In order to work around this limit, use the outer join operator (+) in the WHERE clause of a SELECT statement to specify the join.
Example:
SELECT Customer.Name, SalesRep.RepName
FROM pub.Customer, pub.SalesRep
WHERE Customer.SalesRep(+) = SalesRep.SalesRep
AND Customer.Balance > 40000