Duplicates and Delete Query

User avatar
burrina
4StarLounger
Posts: 550
Joined: 30 Jul 2014, 23:58

Duplicates and Delete Query

Post by burrina »

There is a scenario where the use can create duplicates in a table. I have a query to find those duplicates. Can I use that duplicate query as my delete query ? And if so would I have to add criteria or simply use what the duplicate query found?

User avatar
burrina
4StarLounger
Posts: 550
Joined: 30 Jul 2014, 23:58

Re: Duplicates and Delete Query

Post by burrina »

Issue resolved with a composite key.
Thanks,