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
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