-
Deleting rows from one table where foriegn key doesn't exist in another.
Hi,
I would like to know how to delete rows from one table that are not associated with any rows in another table. Please help me with this. Thanks.
~Lavender
-
Do you need to check other tables? If no, just delete it.
-
deleting table
Yes, I have to check for atleast one more table.
-
Which rdbms do you use? In MS sql, you can use exists to test for the existence of rows.
-
I use 10g. I was able to delete the rows.
thanks.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
|