Unknown table 'a' in MULTI DELETE的解决办法

1、多表联合删除：

DELETE t1,t2 FROM table1 as t1 left join table2 as t2 on t1.ID = t2.TICKETS_ID  WHERE t2.TICKETS_ID = 12;

或者

DELETE table1,table2 FROM table1 left join table2 on table1.ID = table2.TICKETS_ID  WHERE table2.TICKETS_ID = 12;

 

2.在多个表联合删除时，不能使用order by 或limit,而单个表的删除时就没有这个限制。

3.当前，我们还不能在删除表的时候，在子查询中select from相同的表。