delete from 和 left Join连在一起用

有些同学把这两个连在一起用报错，问题在于，没指定删除a表还是b表数据，MySQL很懵逼

DELETE 
a,b
FROM 
	bbibm_purchasing_arrival_goods a 
	left join 
	bbibm_purchasing_arrival_goods_details b 
	on 
	a.number=b.purchasing_arrive_num 
WHERE 
	a.number = '2'

批量删除

DELETE FROM TestTable WHERE ID IN (1, 3, 54, 68)