In Doctrine i can:
$q = Doctrine_Query::create()
->from('One o')
->where('t.text = ?', 'aaa')
->andWhere('h.text = ?', 'bbb')
->leftJoin('o.Two t')
->leftJoin('t.Three h')
->leftJoin('h.Four f')
->execute();
How can i make this in Propel from Symfony 1?
If you use propel before 1.6, you have to follow
You have to know the primary key for each relation. If it's
id
, it can be something like that:For Propel 1.6 (use it from https://github.com/propelorm/sfPropelORMPlugin), something like that:
In relation to j0k answer, an easier way would be: