Archives of the TeradataForum

Message Posted: Tue, 09 Dec 2008 @ 20:56:49 GMT

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

The query that you suggest

     Sel * from source_tbl
        where UPI in (sel UPI from target_tbl),

Shubhangi, doesn't always reveal the problem if the duplication is in the source file. So check it also if the query doesn't give you any records.

Regards

Christer Gronholm

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