求一sql语句 - PHP / 基础编程

有三张表 A,B,C
A里面字段两个products_id（int）和products_model（varchar）
B和C表里面都有products_id这个字段和A表里面的products_id是关联的

比如我现在知道了A表里面的products_model值 我想删除所知道的products_model字段的所有数据以及他的products_id但同时
B和C表里面相对应的products_id也进行删除。

---

引用

SQL code
delete a.*,b.*,c.* from A a
inner join B b on b.products_id = a.products_id
inner join C c on c.products_id = b.products_id
where a.products_model = '值'

谢谢了

---

引用

SQL code
delete a.*,b.*,c.* from A a
inner join B b on b.products_id = a.products_id
inner join C c on c.products_id = b.products_id
where a.products_model = '值'

比如products_model这个值很多啦 该怎么改写啦刚才自己改写了 提示语法错误 。郁闷

---

我的意思products_model假如是200多个这种的语句实现起来比较麻烦 我刚才改了下 但提示语法错误

---

delete zen_products.*,zen_products_discount_quantity.*,zen_products_notifications.* from zen_products a 
inner join zen_products_discount_quantity b on b.products_id = a.products_id
inner join zen_products_notifications c on c.products_id = b.products_id
where a.products_model = '089566'

报错：1109 - Unknown table 'zen_products' in MULTI DELETE