Re: Delete items which aren't present in another table?

Adam Clauss [EMAIL PROTECTED] wrote: I have a table which maintains a list of categories and has a field called catID. This field is a one-to-many relationship with another table. What I want to do is remove any empty categories - aka: remove any categories which aren't used in the second

Delete items which aren't present in another table?

I have a table which maintains a list of categories and has a field called catID. This field is a one-to-many relationship with another table. What I want to do is remove any empty categories - aka: remove any categories which aren't used in the second table. I thought MySQL at least partially