Gossamer Forum
Home : Products : DBMan SQL : Discussion :

getting data from foreign tables

Quote Reply
getting data from foreign tables
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
Subject Author Views Date
Thread getting data from foreign tables jaspercram 2685 Dec 4, 2002, 6:51 AM
Thread Re: [jaspercram] getting data from foreign tables
604 2585 Dec 4, 2002, 10:51 AM
Thread Re: [TheStone] getting data from foreign tables
jaspercram 2543 Dec 9, 2002, 1:38 AM
Post Re: [jaspercram] getting data from foreign tables
604 2531 Dec 9, 2002, 2:30 PM