Archives of the TeradataForum
Message Posted: Fri, 07 Jan 2005 @ 12:08:36 GMT
I for one would use MINUS (ALL). Probably because I am too lazy to write lengthy SQL. Seriously speaking, MINUS is a well-optimized set operation which should give you all the differences on all the columns you specify in SELECTs. Unfortunately, it would not tell which columns exactly differ. You have to do additional processing, if you need that kind of information (apply your lengthy SQL, for example, in the rows returned by the MINUS). Your posting suggests that you don't as row print method would have the same level of feedback.
|Copyright 2016 - All Rights Reserved|
|Last Modified: 28 Jun 2020|