Teradata Database Message 3870 - 3870 - Analytics Database - Teradata Vantage

Message

Alias name cannot match another table/alias name in FROM clause.

Explanation

An alias name is found to match another table name or alias name specified in the same FROM clause of SELECT statement. This causes ambiguity because Teradata Parser cannot tell the user's intention. Two such illegal queries are: SELECT * FROM T1, T2 T1; SELECT * FROM T1 T2, T2 T3;

Generated By

RES modules.

For Whom

End User.

Notes

None

Remedy

Correct the request and resubmit the request.