Consultor Eletrônico



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.