469,921 Members | 2,229 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,921 developers. It's quick & easy.

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

16
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
Feb 3 '11 #1
2 2328
gpl
152 100+
Do you have the authority to add the keys ? If so,add them

If not, post the table structures and the rule for deletion
Feb 3 '11 #2
ck9663
2,878 Expert 2GB
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
Feb 3 '11 #3

Post your reply

Sign in to post your reply or Sign up for a free account.

Similar topics

reply views Thread by Waqarahmed | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.