-
How to Delete Duplicates from Tables with Relationship
about 5 years ago
I would like to know how to delete duplicate cases in a database with tables that are joined through the use of primary key and a foreign key. (Parent and Child). Please see below the two statements below, 1st one showing all duplicates and then second one trying to remove the duplicates but the delete statement conflicts with the references from other tables;
1st one showing all duplicates
Second one trying to remove the duplicates but the delete statement conflicts with the references from other tables
0 Answer(s)