Delete rows with Laravel query builder and LEFT JOIN

laravel-4, left-join, mysql, php, sql-delete

Solution

It seems that my way is not possible. So, I did it like this.

$q = 'DELETE deadline, job FROM deadline LEFT JOIN job ...where deadline.id = ?';        
$status = \DB::delete($q, array($id));

Documentation: http://laravel.com/docs/database#running-queries

Problem

How to delete rows from multiple tables in one query (with left join). The query: ``` DELETE `deadline`, `job` FROM `deadline` LEFT JOIN `job` .... ``` So, I try it like this: ``` DB::table('deadline', 'job') ->leftJoin('job', 'deadline.id', '=', 'job.deadline_id') ->where('deadline.id', $id) ->delete(); ``` Seems that Laravel doesn't support delete from multiple tables with left join. Is there a supported way or workaround?

Original source