hi list.
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
esourceid=$esourceid;"
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?