MySQL DELETE with join Delete a line in a query involving several tables. 2022-11-12 Nicolas Gautron All tutoDatabaseMySQL Delete a line of the table contract DELETE c FROM contract c INNER JOIN client cl ON (cl.id = c.client_id) WHERE cl.name = 'tuto4dev' AND c.end_date < NOW() Please enable JavaScript to view the comments powered by Disqus.