DELETE FROM multiple tables

[code green]

I have a parent table `products` that contains all company products.
The product details are divided amongst 4-5 product details child tables
such as `paper`, `pens`, `books`, `sets`, `pens_paper`.
The 'product_ids` may be in one or more of these child tables but always in `products`.
Is a single DELETE query possible that will delete all occurences of a `product_id` in the tables where the `product_id` occurs.

[Motoma]

I have a parent table `products` that contains all company products.
The product details are divided amongst 4-5 product details child tables
such as `paper`, `pens`, `books`, `sets`, `pens_paper`.
The 'product_ids` may be in one or more of these child tables but always in `products`.
Is a single DELETE query possible that will delete all occurences of a `product_id` in the tables where the `product_id` occurs.

One way to do this would be to use foreign keys between the tables and have cascading deletes in place.

[code green]

Thanks for the reply but I asked for a QUERY that performs a multiple delete based on the conditions.

[code green]

I seem to have solved it without any help.
Will post my solution

--delete id 100 wherever it appears across the database--
DELETE FROM `table1`,`table2`,`table3` USING `table1` 
LEFT JOIN `table2` ON `table2`.`id` = 100  AND any_other_condition_for_table2
LEFT JOIN `table3` ON `table3`.`id` = 100 AND any_other_condition_for_table3
WHERE `table1`.`id` = 100

The left join solves the problem of the possibility of the id not appearing in a certain table