连表查询和连表删除

SELECT * 
FROM erp_orders
LEFT JOIN erp_orders_products ON erp_orders.erp_orders_id = erp_orders_products.erp_orders_id
WHERE erp_orders.orders_export_time > '2014-10-23 00:00:00'
AND erp_orders.sales_account = 'tasteforlife'

 

DELETE erp_orders,erp_orders_products FROM erp_orders LEFT JOIN erp_orders_products

ON erp_orders.erp_orders_id = erp_orders_products.erp_orders_id

WHERE erp_orders.orders_export_time

 

转载于:https://www.cnblogs.com/kobigood/p/4046078.html