Kbase P121780: Error (12480) executing an SQL-92 query with a LEFT OUTER JOIN
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
23/01/2007 |
|
Status: Unverified
FACT(s) (Environment):
OpenEdge 10.1A
SYMPTOM(s):
Error (12480) executing an SQL-92 query with a LEFT OUTER JOIN
ON clause outer join predicate contains invalid column reference. (12480)
=== SQL Exception 1 ===
SQLState=HY000
ErrorCode=-210067
[DataDirect][OpenEdge JDBC Driver][OpenEdge] ON clause outer join predicate contains invalid column reference. (12480)
OpenEdge 10.1A02
CAUSE:
The ON clause of the outer join contains columns that are not in the joined tables.
FIX:
Ensure that all the columns referenced in the ON clause as well as the AND conditions following the ON clause MUST be from the joined tables.