472,145 Members | 2,058 Online
Bytes | Software Development & Data Engineering Community
Post +

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 472,145 software developers and data experts.

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

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 2427
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
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 Saiars | last post: by
reply views Thread by leo001 | last post: by

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.