mysql 关联删除

DELETE t1
FROM
t_sales_query as t1
JOIN t_sales_payment as t2 ON t1.id = t2.sales_id
join t_sales_activity as t3 on t2.ACTIVITY_CODE=t3.ACTIVITY_CODE
WHERE
t3.STATUS=‘‘ and t3.SALES_TIME_END BETWEEN ‘‘ and ‘‘

mysql 关联删除

标签：