Archives of the TeradataForum
Message Posted: Mon, 10 Sep 2001 @ 16:43:22 GMT
It definitely makes a difference whether the date criteria is in the ON statement versus the WHERE clause. Rather than a temp table have you tried a "derived table"? In your example the A table(view) could be a "derived table" (which is the SELECT SQL for that table/view stated in the FROM clause, check the reference manuals).
|Copyright 2016 - All Rights Reserved|
|Last Modified: 28 Jun 2020|