How to write delete mysql query using join in zend
===

This is my mysql simple delete join query. this query is working in mysql. but how i can write this query in zend

DELETE dir FROM directory dir INNER JOIN directory_permission dirper ON  dir.id != dirper.dir_id WHERE dir.dir_name = '$data['deptname']'  and dir.parent = $data['compid']