Khanh Nam Doblog.donamkhanh.com·Dec 18, 2015How to use sub query in MySQL DELETE statement?Just simple as bellow: DELETE FROM clients WHERE id NOT IN ( SELECT * FROM ( SELECT c.id FROM products p INNER JOIN clients c ON c.id = p.supplier_id WHERE c.name = 'Q-IMAGING AUSTRALIA LTD (HEAD OFF...MySQLAdd a thoughtful commentNo comments yetBe the first to start the conversation.