t2和t3数据表中存有他t1表中数据的id
选择删除t1表中的数据以及t2和t3表中相关(task_id)的数据
SQL语句如下:
DELETE t1,t2,t3 from cl_delivery_task t1
LEFT JOIN xh_saleact t2 ON t1.id=t2.task_id
LEFT JOIN xh_sale_detail t3 ON t1.id=t3.task_id
WHERE t1.id='2c27ec183faa4706ba3843c8238ced21'