Archives of the TeradataForum

Message Posted: Thu, 02 Oct 2008 @ 08:38:57 GMT

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

I've just rectified typo in sql syntax.

     select
     A.bla
     from my_table a,
     (select max(load_dte) from another_table) b (LDate)
     where a.period_dte = b.Ldate ;

Thanks.

Best Regards,

Kapil Dev Sapra

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