Unanswered: Delete from multiple tables with one query
I'd like to delete all the items with a specific item code that exist in several tables;
I'm tried variations on the following 2 queries:
DELETE FROM menu_item, rec_blurb, rec_yield, recipe_ingredient_data WHERE rec_code = 'id3d88710d8'
DELETE FROM menu_item m, recipe_ingredient_data r, rec_yield y, rec_blurb b
m.rec_code = 'id3d88710d8'
AND r.rec_code = 'id3d88710d8'
AND y.rec_code = 'id3d88710d8'
AND b.rec_code = 'id3d88710d8'