| |
- Causa
- AN ON CLAUSE IS INVALID.
This return code reports a violation of one of the following:
- One expression of the predicate must only reference columns of one of the operand tables of the associated join operator, full join, and the
other expression of the predicate must only reference columns of the other operand table.
- A VALUE or COALESCE function is allowed in the ON clause only when the join operator is a FULL OUTER JOIN or FULL JOIN.
- An operator other than '=' is not allowed in a FULL OUTER JOIN or FULL JOIN.
- A subquery is not allowed in the ON clause.
- Ação do sistema
- The statement cannot be executed.
- Resposta ao Desenvolvedor
- Correct the syntax so that it doesn't violate any of the above items within the ON clause.
SQLSTATE: 42972
© Copyright IBM Corp.
|
| |
