thx :) On 31 Gru, 20:30, Tom Haskins-Vaughan <[email protected]> wrote: > You need to specify this in your schema: > > City: > columns: > city: > type: string(255) > > Travel: > columns: > id_city_departure: > type: integer > id_city_arrival: > type: integer > relations: > DepartureCity: > class: City > local: id_city_departure > foreign: id > ArrivalCity: > class: City > local: id_city_arrival > foreign: id > > Then for your query: > > $q = Doctrine_Query::create() > ->from('Travel trav') > ->leftJoin('trav.DepartureCity dep') > ->leftJoin('trav.ArrivalCity arr'); > > On Thu, Dec 31, 2009 at 1:40 PM, dziobacz <[email protected]> wrote: > > CITIES: > > id_city > > city > > > TRAVEL: > > id_travel > > id_city_departure > > id_city_arrival > > > How can I make query in that case to get in one row name of departure > > city and name of arrival city ? I have tried something like that but > > it doesn't work: > > > $q = Doctrine_Query::create() > > ->from('Travel trav') > > ->innerJoin('trav.Cities dep ON dep.id_city = trav.id_city_departure') > > ->innerJoin('trav.Cities arr ON arr.id_city = trav.id_city_arrival'); > > > return $q->fetchArray(); > > > -- > > > 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 > > athttp://groups.google.com/group/symfony-users?hl=en. > >
-- 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.
