Teradata Database Message 3509 - 3509 - Analytics Database - Teradata Vantage

Message

The request uses a join condition that Teradata is unable to perform.

Explanation

This error occurs when the query a. has at least two table references in a HAVING clause, as well as two table references somewhere else in the query. b. references an aggregated view with a table join in it (not in its HAVING clause) and the WHERE clause in the query contains an implicit aggregate and a table join. c. references an aggregated view and the WHERE clause in the query contains an implicit aggregate and a table join not in a subquery.

Generated By

OPT modules.

For Whom

End User.

Notes

The query must involve both aggregates and joins. However, note that (a) the join con- dition from the HAVING clause must be done after the aggregate computations, and (b) the join condition specified elsewhere must be done prior to the aggregate computations. Thus, the user cannot execute the join at all.

Remedy

Correct the request and resubmit it.