Re: Find record, that causes DUP_VAL_ON_INDEX [message #39447] |
Wed, 17 July 2002 12:59 |
Mike Muller
Messages: 4 Registered: July 2002
|
Junior Member |
|
|
Obviously I should have started different...
I do have a table, that contains records, which I need to check because of doublets. Doublets are defined by the keys, which have been in the unique-key (this key does ofcoruse not exists on the "real" table, otherwise I wouldn't have the problem :)), in the other statement. So, if I find out, that 4 records are the same, then I need to delete 3 of them and just keep one.
Jes... I don't know, if u understand, what I mean and what I need 2do... :(
greetz
|
|
|