3870 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.
Remedy:
Correct the request and resubmit the request.