Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Thu, 07 Jun 2001 @ 07:59:35 GMT


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


Subj:   Subquery
 
From:   Mats Ginman

I'm trying to make a SELECT statement with a subquery:

select a, (select b from tb where tb.a = ta.a) as c from ta;

The parser returns a syntax error on this.

Is it really so that Teradata does not allow subqueries in this way?

Do you have any suggestions on how to implement the above query in some other way?

Mats Ginman



     
  <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: 27 Dec 2016