Home Page for the TeradataForum

Archives of the TeradataForum

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

  <Prev Next>  
Next> Last>>  

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


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.



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