Sql query to remove duplicate

please what is the sql query to remove duplicates between two tables.?

1 Like

You can’t delete the duplicate using an SQL query. You need to use workflow, query first to find the duplicate, and then loop through each record and delete it. I hope this helps.