K
Kristen
I need a fast way of deleting duplicate records.
This is what I have - an intersection table with 2 fields
(program_code, Key_code). Ideally the combination of these 2 should be
unique within the table. The table SHOULD have a primary key on it to
prevent duplicates, but alas, it does not.
So if I have 2 entries that both have a program_code of 12 and a
key_code of 100, I want to be able to delete the duplicate.
Any advice?
Thanks.
This is what I have - an intersection table with 2 fields
(program_code, Key_code). Ideally the combination of these 2 should be
unique within the table. The table SHOULD have a primary key on it to
prevent duplicates, but alas, it does not.
So if I have 2 entries that both have a program_code of 12 and a
key_code of 100, I want to be able to delete the duplicate.
Any advice?
Thanks.