Sql query to remove duplicate

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