Archives of the TeradataForum
Message Posted: Wed, 29 Sep 2004 @ 16:50:40 GMT
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,
|Copyright 2016 - All Rights Reserved|
|Last Modified: 15 Jun 2023|