please what is the sql query to remove duplicates between two tables.?
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.