Back
Syntax
Study
Editor
Mode:
HTML
CSS
JavaScript
PHP
Reset
Run »
HTML / CSS / JS
-- Delete orders AND their items for cancelled customers DELETE o, oi FROM orders o INNER JOIN order_items oi ON oi.order_id = o.id INNER JOIN customers c ON c.id = o.customer_id WHERE c.status = 'cancelled';
Result
Open