Re: Identifying duplicate records

Sorry It's a bullshit, of course ... i realized in moment of posting. You have to join tables through all columns of table EXCEPT OF primary_key column. Something like

TABLE (PRIMARY_KEY,COLUMN_1,...COLUMN_N) SELECT
  DISTINCT A.PRIMARY_KEY
FROM
  TABLE A, TABLE B
WHERE

  A.COLUMN_1 =  B.COLUMN_1 AND
  A.COLUMN_2 =  B.COLUMN_2 AND
  ..........................................
  A.COLUMN_N =  B.COLUMN_N

Martin Received on Mon Mar 06 2006 - 15:56:00 CST