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 at
http://groups.google.com/group/symfony-users?hl=en.
