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.

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.