I am trying to delete 2 tables using ier join. I have a modifier_category table which is the parent table and the modifier_items table which is the child.
The way they relate is the modifier_categories table primary id which is stored in the cat_id column matches the cat_parent_id in the modifier_items table
I can only look up the modifier_categories table by an item_id.
When I run the query only the modifier_categories table gets deleted but nothing gets deleted in the modifier_items table.
Below is my query I am using. I looked it over at least hundred times and noting seems to be working.
Any help would be really appreciated. Thanks for advanced
DELETE mc FROM modifier_categories mc INNER JOIN modifier_items mi ON mi.cat_parent_id=mc.cat_id WHERE mc.menu_item_id = 28560