Archives of the TeradataForum

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

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

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>>