$q = Doctrine_Query::create() ->select('u') ->from('User u') ->leftJoin('u.Address a') ->where('a.city = ?', 'New York'); $rootAlias = $q->getRootAlias(); // returns 'u'
$q = Doctrine_Query::create() ->select('c.name') ->from('User u') ->leftJoin('u.Address a') ->leftJoin('a.Country c'); $rootAlias = $q->getRootAlias(); // returns 'u'This is a feature of the Doctrine 1.0 library.