Archives of the TeradataForum
Message Posted: Thu, 22 Apr 2004 @ 20:53:37 GMT
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?
|Copyright 2016 - All Rights Reserved|
|Last Modified: 27 Dec 2016|