Archives of the TeradataForum

Message Posted: Fri, 07 Jan 2005 @ 12:08:36 GMT

	<Prev	Next>		<<First	<Prev	Next>	Last>>

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.

Regards,

Victor

	<Prev	Next>		<<First	<Prev	Next>	Last>>