MySQL DELETE with join

Delete a line in a query involving several tables.

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()