Back
Syntax
Study
Editor
Mode:
HTML
CSS
JavaScript
PHP
Reset
Run »
HTML / CSS / JS
-- Delete products that have never been ordered DELETE FROM products WHERE product_id NOT IN ( SELECT product_id FROM ( SELECT DISTINCT product_id FROM order_items ) AS ordered );
Result
Open