How to delete records of one table that exist in another table have no keys?

[anoop s]

I want to delete records of one table that exist in another table. The tables have no primary key. It will take a lot of time compare field by field. Is there any method record by record comparison and deletion

[gpl]

Do you have the authority to add the keys ? If so,add them

If not, post the table structures and the rule for deletion

[ck9663]

How do you know it exists on the other table then? To say it also exists in the other table means there's similarities between the two records in different table. Use those similarities as your link to delete the records.

Good Luck!!!

~~ CK