Archives of the TeradataForum

Message Posted: Mon, 03 Dec 2007 @ 13:07:41 GMT

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

I would assume there are multiple records in the del_fac table with the same key (NUPI?) thus the select will show more than the delete as a row can be deleted only once whereas the select will return all occurences where the join matches

John

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