Archives of the TeradataForum

Message Posted: Thu, 22 Apr 2004 @ 20:53:37 GMT

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

Hi,

try to capture some row by using

     select t1.pk1, t1.pk2, t1.pk3, t1.pk4, t1.pk5, t2.x1, t1.x2, t1.x3,
     t1.x4, t1.x5
     FROM table01 T1, table02 T2
     WHERE T1.pk1 = T2.pk1
     group by t1.pk1, t1.pk2, t1.pk3, t1.pk4, t1.pk5, t2.x1, t1.x2, t1.x3, t1.x4, t1.x5
     having count(*) > 1;

Check the data in the tables afterwards.

Can you publish the DDL's and example data?

Ulrich

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