-338   AN ON CLAUSE IS INVALID

A statement contains an invalid ON clause. Conditions that can cause this error include, but are not limited to, violations of the following requirements:

• For a full join, each expression of the predicate must reference only columns in its own operand tables.
• Only VALUE and COALESCE functions are allowed in the ON clause for full outer joins and full joins.
• Full outer joins and full joins permit only the = operator.
• The ON clause cannot contain a subquery.
• The ON clause cannot contain an XMLEXISTS predicate.