Archives of the TeradataForum
Message Posted: Wed, 18 Jun 2008 @ 19:28:43 GMT
The ON clause defines matching, not filtering. So in Query B you are not "restricting" the number of USING rows processed, just forcing WHEN NOT MATCHED action (i.e. INSERT) for most of them.
|Copyright 2016 - All Rights Reserved|
|Last Modified: 28 Jun 2020|