Archives of the TeradataForum
Message Posted: Wed, 05 Mar 2008 @ 21:18:50 GMT
<-- Anonymously Posted: Wed, 5 Mar 2008 12:20 -->
Think I got the join condition backward relative to your description. Corrected below. At least the important part was right the first time...
WHERE PREV_LEVEL.ACCOUNT_NUMBER_NEW = THIS_LEVEL.ACCOUNT_NUMBER_OLD AND THIS_LEVEL.ACCOUNT_NUMBER_NEW <> THIS_LEVEL.ACCOUNT_NUMBER_OLD
|Copyright 2016 - All Rights Reserved|
|Last Modified: 28 Jun 2020|