Deleting rows with MySQL LEFT JOIN
Solution 1:
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` ....
Solution 2:
If you are using "table as", then specify it to delete.
In the example i delete all table_1 rows which are do not exists in table_2.
DELETE t1 FROM `table_1` t1 LEFT JOIN `table_2` t2 ON t1.`id` = t2.`id` WHERE t2.`id` IS NULL