DQL delete from multiple tables (doctrine)
- by singer
Need to perform DQL delete from multple related tables.
In SQL it is something like this:
DELETE r1,r2
FROM ComRealty_objects r1, com_realty_objects_phones r2
WHERE r1.id IN (10,20) AND r2.id_object IN (10,20)
I need to perform this statement using DQL, but I'm stuck on this :(
<?php
$dql = Doctrine_Query::create()
…
