> 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? You can do this: select geom from table3 where munprovid=(select munprovid from table2 where brgyid=(select brgyid, households from table1 where esourceid=$esourceid)); Chris
