InstantForum.NET v4.1.4Teradata Forumshttp://www.teradata.com/teradataforum/info@teradata.comWed, 03 Dec 2008 15:37:15 GMT20http://www.teradata.com/teradataforum/Topic11720-9-1.aspxOkay thank you very much, it works very fine !Wed, 04 Jun 2008 03:56:34 GMTtonio4531http://www.teradata.com/teradataforum/Topic11720-9-1.aspxYou should be glad about that error message ;-)Your query is an 8-table mixing SQL89 and SQL92 style joins, it would result in cross-joining the result sets of those inner joins.You probably wanted:from table1 AS A, table2 AS B, table3 AS C, table4 AS D, table5 AS EWHERE A.field1=B.field1AND A.field2=C.field2AND A.field1=D.field1AND A.field1=E.field1Rewritten using JOIN syntax:from table1 AS A inner join table2 AS BON A.field1=B.field1inner join table3 AS CON A.field2=C.field2inner join table4 AS DON A.field1=D.field1inner join table5 AS EON A.field1=E.field1DieterTue, 03 Jun 2008 11:35:31 GMTdnoethhttp://www.teradata.com/teradataforum/Topic11720-9-1.aspxHello all,Actually I'm trying to perform the following request and I receive this error :Error 3870: Alias name cannot match another table/alias name in FROM clause.select *from table1 AS A inner join table2 AS BON A.field1=B.field1,A inner join table3 AS CON A.field2=C.field2,A inner join table4 AS DON A.field1=D.field1,A inner join table5 AS EON A.field1=E.field1whereC.DATE1 BETWEEN A.DATE2 and A.DATE2;As far as I can see it, each of my alias does correspond to one single table!So why this error ?Is it forbidden to join the same field of table 1 two times on different tables ?Thank you very much if you find an answer.BRTue, 03 Jun 2008 11:09:11 GMTtonio4531