Teradata Database Message 3870 - 3870 - Analytics Database - Teradata Vantage
Analytics Database Messages
- Deployment
- VantageCloud
- VantageCore
- Edition
- Enterprise
- IntelliFlex
- VMware
- Product
- Analytics Database
- Teradata Vantage
- Release Number
- 15.xx,16.xx,17.xx
- Published
- June 2022
- ft:locale
- en-US
- ft:lastEdition
- 2023-01-05
- dita:mapPath
- sfx1628096178347.ditamap
- dita:ditavalPath
- ft:empty
- dita:id
- B035-1096
- lifecycle
- latest
- Product Category
- 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.