Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Sun, 17 Jul 2005 @ 08:58:56 GMT


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


Subj:   SQL Error: expecting something between ( and the select word
 
From:   Mwambi, Andene

Hi,

Am trying to run the query below but its giving me an error saying "expecting something between ( and the select word"

     select x
          , count(x)

     from x

     where date BETWEEN ( Select Max(rec_date) from y) and ( Select
     add_months(Max(rec_date + 1), -3) - 1 from y)
     + 1), -3) - 1 from A_AFRICA_BASE.accounts)

     group by 1
     order by 1;

Could you please help.


Regards

A.



     
  <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