Archives of the TeradataForum

Message Posted: Thu, 06 Mar 2008 @ 15:09:08 GMT

	<Prev	Next>		<<First	<Prev	Next>	Last>>

          > Select E.Id, E.Name, E.Address,
          >       (select D.Name
          >        from Dept D where E.DId=D.Id)
          > from Employee E;

No, this "recursive select" syntax is not supported by Teradata. Try to move your second Select to the FROM clause and make it a derived table (if you want to keep the Select, that is; you could just join two tables instead.)

Victor

	<Prev	Next>		<<First	<Prev	Next>	Last>>