Deleting rows with MySQL LEFT JOIN
You simply need to specify on which tables to apply the DELETE. Delete only the deadline rows: DELETE `deadline` FROM `deadline` LEFT JOIN `job` …. Delete the deadline and job rows: DELETE `deadline`, `job` FROM `deadline` LEFT JOIN `job` …. Delete only the job rows: DELETE `job` FROM `deadline` LEFT JOIN `job` ….