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


  <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: 15 Jun 2023