Teradata Database Message 3574 - 3574 - Analytics Database - Teradata Vantage

Message

Illegal clause or aggregation in a SELECT with no table accessed.

Explanation

An ORDER BY, GROUP BY, HAVING, or WITH clause, or an aggregate function, such as MIN, MAX, or COUNT, has been used in a SELECT which does not access a table. The listed clauses and aggregate functions are meaningful only for SELECT statements which access at least one table. Zero table selects are also prohibited in FastExport mode.

Generated By

OPT modules.

For Whom

End User.

Notes

None

Remedy

Change the query to access a table or remove the invalid clause or clauses.