Archives of the TeradataForum

Message Posted: Wed, 29 Sep 2004 @ 16:50:40 GMT

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

Gayathri:

Now that you have been told about your missing comma, you have an opportunity to improve the efficiency also. Casting data to character to make a comparison will slow down your query, especially if it is over millions of rows.

I suggest you do the following:

     where a.account_number = b.account_number
        and  a.statement_date/100 = 200408 ;

Hope this helps,

Michael Larkins
Certified Teradata Master
Certified Teradata SQL Instructor

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