Try to use the table names instead of the class names in the subquery. On 29 Jan., 00:54, MaEcTPo <[email protected]> wrote: > I wrote a raw SQL, like this: > > SELECT b2.title, r.title > FROM route r > LEFT JOIN busstop_route b ON (r.id = b.route_id) > LEFT JOIN busstop b2 ON b2.id = b.busstop_id > WHERE b2.id <> 3 > AND b.direction_id = > ( > SELECT ab.direction_id > FROM route ar > LEFT JOIN busstop_route ab ON (ar.id = ab.route_id) > WHERE ab.busstop_id = 3 > AND r.id = ar.id > ); > > And I would like to write it in DQL. All goes good before subquery. > > $q = Doctrine_Query::create() > ->from('Route r'); > $q->leftJoin('r.Directions d'); > $q->leftJoin('r.Busstops b'); > //$q->leftJoin('b.Places'); > $q->andWhere('b.id <> ?', $this->getId()); > $q->andWhere('d.id = ( > SELECT ab.direction_id > FROM Route ar > LEFT JOIN Busstops ab ON (ar.id = ab.route_id) > WHERE ab.busstop_id = 3 > AND r.id = ar.id > )', ''); > > And here I receive strange errors. Symfony talks to me - "Couldn't > find class Busstops". But it has to find relation busstops (like in > main query), not class. When I change Busstops to Busstop I receive > "Unknown relation alias". > > Do you understand what I need to do? > > Please, help!
-- You received this message because you are subscribed to the Google Groups "symfony users" group. To post to this group, send email to [email protected]. To unsubscribe from this group, send email to [email protected]. For more options, visit this group at http://groups.google.com/group/symfony-users?hl=en.
