Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Wed, 14 Jan 2009 @ 21:56:56 GMT


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


Subj:   Re: Syntax error: expected something between '(' and the 'SELECT' keyword
 
From:   Dieter Noeth

geethabhatt wrote:

  I am getting following error msg when I try to run this query. Please advice. Thank you for the help.  


You can't use Scalar Subqueries (i.e. SELECT within SELECT list) before TD13.

Rewrite that query using an Outer Join on a Derived Table pre-aggregating the data


Dieter



     
  <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