Kbase P120001: Outer join error when running a SQL-92 query.
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
10/31/2006 |
|
Status: Unverified
FACT(s) (Environment):
Progress 9.1D
Progress 9.1E
OpenEdge 10.x
SYMPTOM(s):
Outer join error when running a SQL-92 query.
The following error message is displayed:
Outer join specified on a complex predicate (7665)
Error using the (+) outer join notation.
CAUSE:
In an Oracle style outer join using the notation (+), all the joining sides of the expression must be column references. In this case neither user-defined functions nor constants can be used in the outer join expression.
FIX:
There are two ways to get around this problem:
1) Modify the expression to only have references to columns.
2) Use the syntax: LEFT OUTER JOIN.... ON .... or RIGHT OUTER JOIN.... ON ...., which are more general expressions in OpenEdge SQL.