Teradata Database Message 3509 - 17.10 - 3509 - Advanced SQL Engine - Teradata Database

Teradata Vantageā„¢ - Database Messages

Product
Advanced SQL Engine
Teradata Database
Release Number
17.10
Release Date
July 2021
Content Type
Programming Reference
Publication ID
B035-1096-171K
Language
English (United States)
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.