Hi,

Hope someone can help me with this one. I Have the following tables (the relations are known to DBMan SQL):

streets: id, name, city_id
cities: id, name, country_id
countries: id, name

I have a street id and I need the name of the related city and country. What would be an elegant way to do that?

Thanks, Jasper

---

http://www.bookings.org