i have 3 tables with the following columns:
table1: esourceid (primary key), brgyid, households
table2: brgyid (primary key), munprovid
table3: munprovid (primary key), geom
i am given the esourceid and i need to query the brgyid and the households of
a particular esourceid: query1="select brgyid, households from table1 where
the resulting brgyid will then be used to query for the munprovid in table2:
query2="select munprovid from table2 where brgyid=(query1);"
the resulting munprovid will then be used to query for the geom column:
"select geom from table3 where munprovid=(query2);"
my question is, how do i do this? any ideas?
pgsql-php by date
|Next:||From: Christopher Kings-Lynne||Date: 2003-03-07 05:30:49|
|Subject: Re: querying from 3 tables|
|Previous:||From: Travel Jadoo||Date: 2003-03-01 11:12:36|