Home Page for the TeradataForum

Archives of the TeradataForum

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

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

Subj:   Re: Teradata Query with Subselect
From:   Victor Sokovin

  Can I write query in Teradata Quarrymen as below  

          > 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.)


  <Prev Next>   <<First <Prev Next> Last>>  
  Top Home Privacy Feedback  
Copyright for the TeradataForum (TDATA-L), Manta BlueSky    
Copyright 2016 - All Rights Reserved    
Last Modified: 28 Jun 2020